judgehopkins
Technical User
If you look in the expression builder under common expressions, you will find that Microsoft says the correct way to print Page X of Y on a report is:
However, the correct expression is:
Admittedly, once you paste the incorrect expression into the event where you want it and press ENTER, Access corrects itself.
Judge Hopkins
There are only two rules for success: (1) Never tell everything you know.
Code:
"Page " & Page & " of " & PagesHowever, the correct expression is:
Code:
="Page " & [Page] & " of " & [Pages]Admittedly, once you paste the incorrect expression into the event where you want it and press ENTER, Access corrects itself.
Judge Hopkins
There are only two rules for success: (1) Never tell everything you know.
