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

• Microsoft Access versions 7.0, 97

SUMMARY

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

In Microsoft Access 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:

   ARTICLE-ID: Q145777
   TITLE     : ACC95: Microsoft Access Sample Reports Available on MSL

   ARTICLE-ID: Q175072
   TITLE     : ACC97: Microsoft Access 97 Sample Reports Available on MSL

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.

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          : RptSort kbusage
Version           : 7.0 97
Platform          : WINDOWS
Hardware          : x86
Issue type        : kbhowto