|
The report wizard automatically puts page numbers onto reports , or you can put them in yourself in design mode (you can simply add them from the Insert menu), but let's add them manually so you can see what these other methods actually do.
In the page footer add a new textbox. Place it at the right of the page.
Bring up the Properties for the new textbox, select the Data tab and add the following code into the Control Source property:
= "Page " & [Page] & " of " & [Pages]
Delete the label for this textbox, as we won't need it.
Switch the report to Preview mode and have a look at the bottom of the page.
How It Works
This is really simple. You know that we use the and symbol (&) to join strings together in expressions. Well, Page and Pages are predefined fields within any report, and identify the current page number and the total number of pages. We enclose them in square brackets to tell Access that these are fields and not strings.
|