Microsoft KB Archive/138770

= ACC: Repeating Group Name at Top of New Column or Page (95/97) =

Article ID: 138770

Article Last Modified on 1/19/2007

-

APPLIES TO


 * Microsoft Access 95 Standard Edition
 * Microsoft Access 97 Standard Edition

-



This article was previously published under Q138770



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



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 files, RptSampl.exe (for Microsoft Access for Windows 95 version 7.0) and RptSmp97.exe (for Microsoft Access 97). For information about how to obtain these sample files, please see the following articles in the Microsoft Knowledge Base:

145777 ACC95: Microsoft Access Sample Reports in Download Center

175072 ACC97: Microsoft Access 97 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 a report's Report Design view, if it is not displayed, display the property sheet for the group header section you want to repeat.
 * 2) Set the group header section's RepeatSection property to Yes.

