Add page numbers to an Access report

When you create a report from scratch in Microsoft Access, sometimes you don't get to utilize all of the handy benefits of the report wizard. For instance, learn how to manually add the page number control to an Access report.

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:

  1. In the Design view, select Text Box on the Toolbox.
  2. Click and drag it in the Page Footer section where you want the page number to appear.
  3. Select the Label Control Text and replace it with Page.
  4. Click twice on the Text Control Box and enter the following formula:
  1. Press Enter.

The Access Page function automatically numbers the pages in your report.

Editor's Picks

Free Newsletters, In your Inbox