Form.OrderByOn Property (Access)
You can use the OrderByOn property to specify whether an object's OrderBy property setting is applied. Read/write Boolean.
Syntax
expression .OrderByOn
expression A variable that represents a Form object.
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. |
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