-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Sorting
- Thread starter jump25a
- Start date
ffice
></o
xenou
MrExcel MVP
- Joined
- Mar 2, 2007
- Messages
- 16,836
- Office Version
- 2019
- Platform
- Windows
Depending on what version of access you are using, memo fields may not be able to be sorted.
Some links (these were frankly very easy to find - there is plenty at google on this):
http://www.access-programmers.co.uk/forums/showthread.php?t=104047
http://www.pcreview.co.uk/forums/do-sort-memo-fields-access-2007-a-t3514231.html
Workaround (Generally) is to create a query that has the first 10 or so characters of the memo text as a sort field.
The nature of memos is that you don't typically put data in their that requires sorting (such long strings are not good sort fields to begin with).
ξ
Some links (these were frankly very easy to find - there is plenty at google on this):
http://www.access-programmers.co.uk/forums/showthread.php?t=104047
http://www.pcreview.co.uk/forums/do-sort-memo-fields-access-2007-a-t3514231.html
Workaround (Generally) is to create a query that has the first 10 or so characters of the memo text as a sort field.
The nature of memos is that you don't typically put data in their that requires sorting (such long strings are not good sort fields to begin with).
ξ
Upvote
0
