How Can I Test For Page Number Follow
I am trying to test for the page number and I cannot seem to use my formula in an If..Then..Else.
I have a datasource called PageNum that works. When I preview my labels that field correctly displays the page number.
I created the following:
If Format.NamedSubStrings("PageNum").Value = "1" Then
Value = "Page 1"
Value = "Not Page 1"
If I test for string length It looks like the string is 3 characters wide ( I am only printing 4 labels so I would expect this number to be 1). I tried adding vbCrLf to the end of my "1" however the If..Then..Else always returns false.
One factor here to consider is that I am using a formula to calculate the number of pages to print based on a quantity field in the DB.
Aaaaaaaaarg - I must be doing something stupid here - any help greatly appreciated.
Dave Oender - 6541-246-3281
Please sign in to leave a comment.