Fix Access Report Last Page Displaying Page 1 Incorrectly
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.

- 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 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.
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.
Right-click your report in the Navigation Pane and select 'Design View'.
Scroll to the Page Footer or Report Footer section where your page number text box (e.g., =[Page]) is located.
Click the text box to select it. Click and drag the sizing handles on the left or right edge to make the box wider.
Switch back to 'Print Preview' mode and navigate to the last page to verify the number is now displaying correctly.

Review VBA Code for Page Resets
Custom VBA macros or event procedures attached to the report might be forcing the Page property to reset to 1.
Check Subreports and Grouping Properties
Check this if your report contains complex groupings or embedded subreports that have their own pagination settings.
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. Download WPS Office: Visit the official WPS Office website and click the free download button for your operating system.
- 2. Install the Software: Run the downloaded installer file and follow the on-screen instructions to complete the setup.
- 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.

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.




