ACC2000: How to Repeat Group Name at Top of New Column or Page (208732)

Novice: Requires knowledge of the user interface on single-user computers.

This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).

SUMMARY

You can use the RepeatSection property to specify whether a group header is repeated on the next page or column when a group spans more than one page or column.

NOTE: This article explains a technique demonstrated in the sample file, RptSmp00.mdb. For information about how to obtain this sample file, please see the following article in the Microsoft Knowledge Base:

231851 ACC2000: Microsoft Access 2000 Sample Reports Available in Download Center

MORE INFORMATION

In reports, group header information is printed once per group even if the group data spans more than one page. In reports, a common layout is to place the grouping value in the group header along with the column labels. However, because this data is not repeated when a group spans more than one page, the column header labels are not repeated on the subsequent page(s).

The following steps illustrate how to use the RepeatSection property to print the group header on another page or column:

In the Design view of a report, if it is not displayed, display the property sheet for the group header section that you want to repeat.
Set the RepeatSection property of the group header section to Yes.

REFERENCES

For more information about printing group headers on subsequent pages, click Microsoft Access Help on the Help menu, type RepeatSection in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.

For an example of this feature, refer to the Northwind database in the Samples folder. Open the Employee Sales By Country report. Note that GroupHeader2 has the RepeatSection property set to Yes.