We have an Access 2000 application that connects to a shared database and allows users to run reports as well as enter new data.
There is an account view that lets them do a list view of the database table. This is convenient if you want to look right at the database.
In the past, the "name" field had been a Text type, which limits it to 255 characters, but also allows it to be sorted in the list view (right click on the column name, then select "Asending/Descending" from the menu).
But new clients with very long names (companies and sub companies) have no required us to go beyond the 255 characters of the Text type and move up to the Memo type (which has the slightly excessive 65K characters for our uses on this one).
But now that seems to have broken the sort via right-clicking in the list view.
I have been able to successfully do a Records->Filter->Advances Sort/Filter and then in there do a descending/ascending SQL query on it - but I don't suspect our users of this app are going to be too happy to have to do that.
I looked on the MS site and they seem to indicate that Access 2003 *will* sort memo types, but only the first 255 chars of them (which is perfectly fine for what we need) - but we don't have Access 2003 and can't budget that right now.
Is there a way we can get that right-click funtionality back for our memo type field?
Thanks!
There is an account view that lets them do a list view of the database table. This is convenient if you want to look right at the database.
In the past, the "name" field had been a Text type, which limits it to 255 characters, but also allows it to be sorted in the list view (right click on the column name, then select "Asending/Descending" from the menu).
But new clients with very long names (companies and sub companies) have no required us to go beyond the 255 characters of the Text type and move up to the Memo type (which has the slightly excessive 65K characters for our uses on this one).
But now that seems to have broken the sort via right-clicking in the list view.
I have been able to successfully do a Records->Filter->Advances Sort/Filter and then in there do a descending/ascending SQL query on it - but I don't suspect our users of this app are going to be too happy to have to do that.
I looked on the MS site and they seem to indicate that Access 2003 *will* sort memo types, but only the first 255 chars of them (which is perfectly fine for what we need) - but we don't have Access 2003 and can't budget that right now.
Is there a way we can get that right-click funtionality back for our memo type field?
Thanks!
