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

ID: Q208732

The information in this article applies to:
Novice: Requires knowledge of the user interface on single-user computers.

This article applies to a Microsoft Access database (.mdb) and 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.


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.



REFERENCES

For more information about printing group headers on subsequent pages, click Microsoft Access Help on the Help menu, type "RepeatSection" in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.

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.

Additional query words: 


Keywords          : kbusage kbdta RptSort 
Version           : WINDOWS:2000
Platform          : WINDOWS 
Issue type        : kbhowto

Last Reviewed: June 10, 1999