Order By - removing when closing form

[Guest]

How can I remove a string from the 'Order by' property on a Form's property
sheet when closing a Form wit an event proceedure on the On Close event?

Many thanks.

 

[Allen Browne]

Don't worry about it John. OrderBy is not applied unless you set OrderByOn
as well.

If it really matters that the value is blank next time the form opens, clear
it it the form's Open event:
Me.OrderBy = vbNullString