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

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.