GroupLevel object (Access)

Use the GroupLevel property in Visual Basic to refer to the group level that you are grouping or sorting on in a report.

Remarks

The GroupLevel property setting is an array in which each entry identifies a group level. To refer to a group level, use this syntax:

GroupLevel (n)

The number n is the group level, starting with 0. The first field or expression that you group on is group level 0, the second is group level 1, and so on. You can have up to 10 group levels (0 to 9).

The following sample settings show how you use the GroupLevel property to refer to a group level.

Use this property only by using Visual Basic to set the SortOrder, GroupOn, GroupInterval, KeepTogether, and ControlSource properties. You set these properties in the Open event procedure of a report.

In reports, you can group or sort on more than one field or expression. Each field or expression that you group or sort on is a group level.

You specify the fields and expressions to sort and group on by using the CreateGroupLevel method.

If a group is already defined for a report (the GroupLevel property is set to 0), you can use the ControlSource property to change the group level in the report's Open event procedure.

For example, the following code changes the ControlSource property to a value contained in the txtPromptYou text box on the open form named SortForm.

Private Sub Report_Open(Cancel As Integer) 
 Me.GroupLevel(0).ControlSource _ 
 = Forms!SortForm!txtPromptYou 
End Sub

Properties

• Application
• ControlSource
• GroupFooter
• GroupHeader
• GroupInterval
• GroupOn
• KeepTogether
• Parent
• Properties
• SortOrder

See also

• Access Object Model Reference

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.