Report footer - Page of Pages

S

SAC

I'm puttin gthis in the bootom of a report from the report wizard:

="Page " & [Page] & " of " & [Pages]

and I'm getting this:

#Name?

It's just on one report.

Any ideas?

Thanks.
 
A

Allen Browne

Try changing the Name of this text box. Access gets confused if the text box
has the same name as a field, but is bound to something else. You could also
have problems if you have a field named Page or Pages.

Also, make sure there is nothing in the Format property of the text box.

If those simple steps don't solve it, break it down to see which part is
failing, i.e. try:
="Page " & [Page]
and if that works, try:
=" of " & [Pages]

Post a reply if you are still stuck.
 
Top