[AccessD] Reset OrderBy

Michael R Mattys mmattys at rochester.rr.com
Tue Feb 20 20:18:25 CST 2007


Hi Susan,

If I recall correctly, you'd use .OrderByOn = False

Michael R. Mattys
MapPoint & Access Dev
www.mattysconsulting.com

----- Original Message ----- 
From: "Susan Harkins" <ssharkins at setel.com>
To: "'Access Developers discussion and problem solving'" 
<accessd at databaseadvisors.com>
Sent: Tuesday, February 20, 2007 9:04 PM
Subject: [AccessD] Reset OrderBy


> 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.
>
> Susan H.
>
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com 




More information about the AccessD mailing list