[AccessD] Access 2007 - How to unfilter / unsort

I wasn't looking in the toolbar.

Notice that you have to be in the home toolbar to even see that.

Access 2007 (and above) is just clumsy to do real development in. I have been using it exclusively 
for almost 4 months now and still hate it.  Which toolbar was that XYZ in again?  Hmmm... let's 
click through all of them and look for it.  Oh and what exactly am I looking for anyway?

Can you say major suckage?

I can filter in the grid and clear the filter in the grid (right click menu).  I expected that since 
I could sort right in the grid, I could clear the sort right in the grid.  Uhhhh no.

Can you say major suckage?

John W. Colby

Reality is what refuses to go away
when you do not believe in it

On 5/21/2013 1:01 PM, David A Gibson wrote:
> I don't know about Access 2007 but in 2010 there is a "Clear All Sorts"
> button beneath the ascending and descending arrows.
>
> David Gibson
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of John W Colby
> Sent: Tuesday, May 21, 2013 10:48 AM
> To: Access Developers discussion and problem solving
> Subject: [AccessD] Access 2007 - How to unfilter / unsort
>
> When I open a table I can set a sort order on a column, but when I click the
> little arrow, there is no clear filter.  Well... it is n't a filter it is a
> sort.  But there is no "clear sort" either.  So...
>
> When I sort a table (or query) on a column in the data grid, how do I clear
> the sort, short of closing the table without a save.
>
> --
> John W. Colby
>
> Reality is what refuses to go away
> when you do not believe in it
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>