RepeatSection Property

Microsoft Access Visual Basic

RepeatSection Property

       

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

expression.RepeatSection

expression   Required. An expression that returns one of the objects in the Applies To list.

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.
You can set the RepeatSection property by using the group header section's property sheet, a macro, or Visual Basic.

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