totn Access

MS Access 2003: Create a report title that repeats on every page

This MSAccess tutorial explains how to create a report title that repeats on every page of a report in Access 2003 (with screenshots and step-by-step instructions).

Question: In Microsoft Access 2003/XP/2000/97, how can I format a report so that the title will appear on the first page and also on subsequent pages?

Answer: Most people create their title in the Report Header section of the Access Report. By default, the Report Header only displays on the first page of the report, not on the subsequent pages.

To set up a title that appears on every page, it is easiest to move your title to the Page Header section of the report.

To do this, open your report in design view.

Microsoft Access

Make sure that your Page Header section is visible by selecting Page Header/Footer under the View menu.

Microsoft Access

Next, drag the fields from the Report Header section down to the Page Header section.

Microsoft Access

Now your title should appear on all pages of your Access report.