Microsoft KB Archive/208732

= ACC2000: How to Repeat Group Name at Top of New Column or Page =

Article ID: 208732

Article Last Modified on 7/15/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q208732



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:
 * 1) 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.
 * 2) Set the RepeatSection property of the group header section to Yes.

