[AccessD] Access 2007 - How to unfilter / unsort

David A Gibson davidalangibson2010 at gmail.com
Tue May 21 11:57:23 CDT 2013


Direct from the horse.

http://office.microsoft.com/en-us/access-help/undo-or-remove-a-sort-order-HP
005188308.aspx

To remove the current sort order in Datasheet view or Form view, on the
Records menu, click Remove Filter/Sort. This removes the current or saved
sort order of a table, query, or form.

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



More information about the AccessD mailing list