Section.RepeatSection property (Access)

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. Read/write Boolean.

Syntax

expression.RepeatSection

expression A variable that represents a Section object.

Remarks

The RepeatSection property only applies to group headers on a report.

The RepeatSection property uses the following settings.

Setting Visual Basic Description
Yes True The group header is repeated.
No False (Default) The group header isn't repeated.

When printing a report that contains a subreport, the subreport's RepeatSection property will determine if the subreport group headers are repeated across pages or columns.

Example

The following example prints the group header "GroupHeader0" at the top of each page.

Reports("Purchase Order").Section("GroupHeader0").RepeatSection = True

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.