This documentation is archived and is not being maintained.

GroupLevel.SortOrder Property (Access)

You use the SortOrder property to specify the sort order for fields and expressions in a report. For example, if you're printing a list of suppliers, you can sort the records alphabetically by company name. Read/write Boolean.

expression .SortOrder

expression A variable that represents a GroupLevel object.

The SortOrder property uses the following settings.

Setting

Visual Basic

Description

Ascending

False

(Default) Sorts values in ascending (A to Z, 0 to 9) order.

Descending

True

Sorts values in descending (Z to A, 9 to 0) order.

In Visual Basic, you set the SortOrder property in report Design view or in the Open event procedure of a report by using the GroupLevel property.

The following example sets the sort order to ascending for the first group level in the "Product Summary" report.

Reports("Product Summary").GroupLevel(0).SortOrder = False 

Show: