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 Required. An expression that returns one of the objects in the Applies To list.
Remarks
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. |
Note: You can set the SortOrder property by using the Group, Sort, and Total pane, a macro, or Visual Basic for Applications (VBA) code.
In Visual Basic, you set the SortOrder property in Design view, Layout view, or in the Open event procedure of a report by using the GroupLevel property.
Example
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
