Help users increase productivity by automatically signing up for TechRepublic's free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.
The report wizard in Microsoft Access automatically adds a page number control to a report. However, if you're creating a report from scratch, you will need to add the necessary control yourself.
Here's how to add the page number control:
- In the Design view, select Text Box on the Toolbox.
- Click and drag it in the Page Footer section where you want the page number to appear.
- Select the Label Control Text and replace it with Page.
- Click twice on the Text Control Box and enter the following formula:
- Press Enter.
The Access Page function automatically numbers the pages in your report.