[AccessD] Reset OrderBy

On 20 Feb 2007 at 21:04, Susan Harkins wrote:

> I'm using a simple procedure to set a form's OrderBy property. When I close
> the form, I want to delete any setting, so that the property isn't saved
> with the form. How can I do that? I tried 
> 
> Private Sub Form_Close()
>   'Reset Order By property
>   Me.OrderBy = ""
> End Sub
> 
> But it doesn't work. Checked Help but didn't find anything helpful. I don't
> really want to set the sort order to "" -- I just want to wipe it clean. My
> guess is the property doesn't recognize "", although it doesn't error. 

It's been a bug since A97 at least.
See 
http://groups.google.com/group/comp.databases.ms-
access/browse_thread/thread/ebaf98ff09ceec48/237910f76c0b80a0%23237910
f76c0b80a0
(watch for wrap)


Putting Me.OrderBy = ""   in Form_Load does work, so do it there to 
insclear any old info instead.

-- 
Stuart