GroupHeader, GroupFooter Properties

Applies To Report.

Description

You can use the GroupHeader and GroupFooter properties to create a group header or a group footer for a selected field or expression in a report. You can use group headers and footers to label or summarize data in a group of records. For example, if you set the GroupHeader property to Yes for the Categories field, each group of products will begin with its category name.

Setting

The GroupHeader and GroupFooter properties use the following settings.

Setting	Description

Yes	Creates a group header or footer.
No	(Default) Doesn't create a group header or footer.

You set these properties in the Sorting And Grouping box.

You can set these properties only in report Design view.

Note You can't set or refer to these properties directly in Visual Basic. To create a group header or footer for a field or expression in Visual Basic, use the CreateGroupLevel function.

Remarks

To set the grouping properties — GroupOn, GroupInterval, and KeepTogether — to other than their default values, you must first set the GroupHeader or GroupFooter property or both to Yes for the selected field or expression.

See Also CreateGroupLevel function, GroupInterval property, GroupLevel property, GroupOn property, KeepTogether property — groups, SortOrder property.