Link to home
Avatar of SteveL13
SteveL13Flag for United States of America

asked on

Trying to put special text in page footer

I'm trying to use this code in the page footer of a report starting with the 2nd page.  But all I'm getting is the first character in a field

=IIf(([Page]>1),Left([txtFirstName]&". "&[txtLastName],1))

Note that txtFirstName and txtLastName are hidden fields on the report.
Avatar of Scott McDaniel (EE MVE )
Scott McDaniel (EE MVE )
Flag of United States of America image

What have you tried to fix it so far? First place I would look would be that LEFT call. LEFT and RIGHT trim off specified numbers of characters, so that would be the most likely place to start.
The result you are getting is because you asked for 1 character from the left of the name.
Replace 1 with 10 to see the effect.
If trying to display the full name, then remove the Left function.
ASKER CERTIFIED SOLUTION
Avatar of SteveL13
SteveL13
Flag of United States of America image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Yes, that makes sense.
Avatar of SteveL13

ASKER

I solved my own issue by re-working the syntax.