OrderByOn Property
Applies to
Form Object |
Report Object |
You can use the OrderByOn property to specify whether an object's OrderBy property setting is applied. Read/write Boolean.
expression.OrderByOn
expression Required. An expression that returns one of the objects in the Applies To list.
Remarks
The OrderByOn property uses the following settings.
Setting | Visual Basic | Description |
Yes | True | The OrderBy property setting is applied when the object is opened. |
No | False | (Default) The OrderBy property setting isn't applied when the object is opened. |
Note: For reports, you can set the OrderByOn property by using the report's property sheet, a macro, or Visual Basic for Applications (VBA) code.
For all other objects, you can set the OrderByOn property by clicking a Sort button under Sort & Filter on the Home tab, or by using VBA.
When a new object is created, it inherits the RecordSource , Filter , OrderBy, OrderByOn, and FilterOn properties of the table or query it was created from.
Example
The following example displays a message indicating the state of the OrderByOn property for the "Mailing List" form.
MsgBox "OrderByOn property is " & _
Forms("Mailing List").OrderByOn
No comments:
Post a Comment