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