David A Gibson
davidalangibson2010 at gmail.com
Tue May 21 12:01:40 CDT 2013
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