'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Show the Page Header Before the Report Header in Access
Question details
The user wants to display the Page Header before the Report Header on the first printed page of a Microsoft Access report.
- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- Designing a custom report layout where specific page-level information needs to appear at the very top of the first page, preceding the overall report title or header.
- Observed behavior
- Microsoft Access enforces a fixed section order where the Report Header always precedes the Page Header on the first printed page, which cannot be directly rearranged in the design view.
Ensure you have your Microsoft Access database open, navigate to your desired report, and switch to Design View to prepare for layout modifications.
Use a Top-Level Group Header to Reorder Content
Since the default report section order is fixed, you can create a custom group based on a constant expression to act as a substitute for the Report Header, allowing the Page Header to print first.
Microsoft Access rigidly orders report sections: Report Header, Page Header, Group Header, Detail, Group Footer, Page Footer, Report Footer. By moving your report-level data into a top-level group that does not repeat, you visually achieve the desired layout without breaking the underlying engine rules.
Open your report in Design View. On the Ribbon, go to the Report Design Tools menu and click 'Group & Sort' to open the Group, Sort, and Total pane at the bottom of the screen.
Click 'Add a group'. Instead of selecting a field from your table, click 'Expression' (or simply type) and enter `=1` as the grouping value. This creates a group that encompasses all records.
Click 'More' on your newly created group in the pane. Ensure the 'with a header section' option is selected. Verify that it is set to 'do not keep group together on one page' and 'do not repeat section on next page'.
Select all the controls (such as title labels or text boxes) currently residing in your Report Header. Cut them and paste them directly into your new Group Header section.
Right-click the original Report Header bar and select 'Report Header/Footer' to remove the section entirely, or simply click and drag the bottom edge of the Report Header up to reduce its height to zero.
Looking for a Lightweight Office Suite?
While WPS Office does not include a direct replacement for Microsoft Access databases, it provides a highly compatible, free alternative for your daily document, spreadsheet, and presentation tasks. If you regularly export Access report data to Excel or PDF, WPS Office handles these formats effortlessly.
- 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 installer and follow the on-screen prompts to complete the lightweight installation process.
- 3. Open Exported Data: Launch WPS Spreadsheet or PDF to seamlessly open and format data exported from your Microsoft Access reports.
Frequently Asked Questions
Can I move the Report Footer before the Page Footer?
Like the headers, Access enforces a fixed footer order where the Page Footer always appears before the Report Footer. You can use a similar technique by enabling the Group Footer for your '=1' constant group and placing your report-level totals there, which will print before the Page Footer.
Why does Access enforce this specific header order?
Access is designed with traditional reporting principles where the Report Header acts as the report's cover page or primary title. Theoretically, this must precede any page-level information like page numbers, dates, or column headers.
How do I hide the Page Header on the first page entirely?
Open your report in Design View, double-click the report selector (the square in the upper-left corner) to open the Property Sheet. Look for the 'Page Header' property and change it from 'All Pages' to 'Not with Rpt Hdr'. This prevents the Page Header from displaying on the same page as the Report Header.
