Order By - removing when closing form

J

John

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.
 
A

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
 
Top