Printing Problems

How to Repeat Subreport Headings on Every Access Report Page

Algirdas Jasaitis Oct 21, 2026 869 views

Question details

The user needs table headings within a subreport to repeat on every printed page when the subreport spans multiple pages.

How to Repeat Subreport Headings on Every Access Report Page

Product: Microsoft Access
Device & OS: not provided
Scenario: Printing a Microsoft Access report that contains a multi-page subreport with column headings.
Observed behavior: The subreport's column headings only appear on the first page and disappear on subsequent pages, even though the main report headings repeat correctly.

Before you start

Ensure your database is saved and you are working in Design View for your Microsoft Access Report. Verify that you are modifying a Report object rather than a Form, as forms lack the advanced grouping capabilities needed for multi-page printing.

Solution 1Recommended

Use Group Headers Instead of Page Headers for the Subreport

Since a subreport's page header only renders once, moving the headings to a Group Header with the 'Repeat Section' property enabled ensures they appear on every page.

In Microsoft Access, a subreport's page header section is designed to only render once at the beginning of the subreport. To force headings to repeat on every new printed page, you must utilize the Grouping feature and place your labels inside a Group Header section.

Open Subreport in Design View

Locate your subreport in the Navigation Pane, right-click it, and select 'Design View'.

Access Group & Sort Settings

Click on 'Group & Sort' in the Design tab on the top ribbon to open the Group, Sort, and Total pane at the bottom of the screen.

Add a Group Header

Add a group based on a constant value or your primary key to encompass the entire subreport data. Ensure the 'with a header section' option is selected for this group.

Move the Headings

Cut your column heading labels from the Subreport Page Header section and paste them into the newly created Group Header section.

Enable Repeat Section

Click on the Group Header section bar to select it, open the Property Sheet (F4), navigate to the Format tab, and change the 'Repeat Section' property to 'Yes'.

Use Group Headers Instead of Page Headers for the Subreport

Verification Step: Switch your main report to Print Preview mode to verify that the subreport headings now successfully appear at the top of every subsequent page.

Solution 2

Convert Forms to Reports for Printing

Forms are optimized for on-screen interaction and do not paginate properly for printing. Converting a Form to a Report prevents disappearing headers.

Free Microsoft Office alternative

Looking for a Lightweight Office Suite?

While Microsoft Access is designed for complex database management, your everyday documentation, data analysis, and presentation tasks can be handled seamlessly with WPS Office. It provides a highly compatible and lightweight alternative to Microsoft Word, Excel, and PowerPoint without the heavy subscription fees.

Highly compatible with Microsoft Office formats (DOCX, XLSX, PPTX).Rich spreadsheet tools for data management and reporting similar to Excel.Lightweight architecture that runs smoothly even on older devices.Free to download with an intuitive, familiar user interface.

microsoft office alternative - wps office

Frequently Asked Questions

Why do main report headers print correctly but subreport headers do not?

Main report page headers are controlled by the primary report's pagination. A subreport is treated as a single embedded control within the main report, so its internal page header only triggers once when the subreport begins rendering.

Can I force a page break before a subreport in Microsoft Access?

Yes. You can insert a Page Break control from the Design toolbox just above your subreport in the main report's design view, or select the report section containing the subreport and set its 'Force New Page' property to 'Before Section'.

Is it possible to print subforms directly instead of using reports?

While Access allows you to print forms, they are designed strictly for on-screen data interaction. Forms lack the robust grouping, sorting, and repeating section capabilities of Reports, which often leads to missing headers, truncated text, or incorrect pagination.

Document & File Issues