Office Settings & Configuration

Fix Access Report Last Page Displaying Page 1 Incorrectly

Steven ParkerSteven Parker Nov 4, 2026 868 views

Question details

The user needs to fix a pagination error in a Microsoft Access report where all pages show the correct page number except the final page, which resets to or incorrectly displays as Page 1.

How to Fix Access Report Last Page Displaying Page 1
Product
Microsoft Access
Device & OS
not provided
Scenario
Previewing or printing a multi-page report containing page number controls.
Observed behavior
The report paginates correctly until the last page, which displays Page 1 instead of the actual final page number.
Before you start

Before altering the report's design, check if the issue occurs only in Print Preview by performing a physical print or exporting the report to PDF.

Solution 1Recommended

Widen the Page-Number Control Box

Use this solution if your report has 10 or more pages. A narrow text box can truncate double-digit numbers, causing a '10' or '11' to visually appear as a '1'.

One of the most common causes of incorrect page numbers on the final pages of an Access report is an inadequately sized text box control. If the text box is too narrow, Access may cut off the second digit of the page number.

1
Open Report in Design View

Right-click your report in the Navigation Pane and select 'Design View'.

2
Locate the Page Number Control

Scroll to the Page Footer or Report Footer section where your page number text box (e.g., =[Page]) is located.

3
Resize the Text Box

Click the text box to select it. Click and drag the sizing handles on the left or right edge to make the box wider.

4
Preview the Report

Switch back to 'Print Preview' mode and navigate to the last page to verify the number is now displaying correctly.

Widen the Page-Number Control Box
Formatting Tip: You can also set the 'Can Grow' property of the text box to 'Yes' in the Property Sheet to ensure it expands automatically if the number gets larger.
Free Microsoft Office alternative

Discover WPS Office for Your Documents and Spreadsheets

While WPS Office does not include a relational database program like Microsoft Access, it is an exceptional, free alternative for Word, Excel, and PowerPoint. If you export your Access data to spreadsheets or reports, you can seamlessly analyze and format them using WPS Spreadsheet and WPS Writer.

  1. 1. Download WPS Office: Visit the official WPS Office website and click the free download button for your operating system.
  2. 2. Install the Software: Run the downloaded installer file and follow the on-screen instructions to complete the setup.
  3. 3. Import Your Data: Export your Access data as an Excel or CSV file, then open it directly in WPS Spreadsheet for further analysis and reporting.
Highly compatible with Microsoft Excel (.xlsx) and Word (.docx) formatsLightweight suite that installs quickly and runs smoothly on older devicesClean, tabbed interface similar to standard web browsers for easy multitaskingBuilt-in PDF toolkit for converting exported reports into easily shareable files
microsoft office alternative - wps office

Frequently Asked Questions

Why does my Access report page number show '[Page]' instead of the actual number?

This happens if the control source is typed incorrectly. You must include an equal sign. Ensure the text box Control Source property is set exactly to '=[Page]' rather than just '[Page]'.

How do I display 'Page 1 of 10' in my Access report?

To show the current page along with the total page count, change the text box Control Source to: ="Page " & [Page] & " of " & [Pages].

Does Print Preview always show the exact printed output in Access?

Usually, yes. However, differences in default printer drivers or margins can occasionally cause the physical printout to paginate slightly differently than the Print Preview. Always test print a complex report if pagination issues arise.