RepeatSection Property [Access 2003 VBA Language Reference]

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.

Note  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

Applies to | Section Object