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:
- 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.
- Set the group header section's RepeatSection property to Yes.
REFERENCES
For more information about printing groupheaders on subsequent pages, search in the Help Index for "RepeatSection," or ask the Microsoft Access 97 Office Assistant.
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.
Keywords: kbhowto kbusage KB138770