0

I have a table with two memo fields. Neither of which I can sort on. The sorting options on the menu is grayed out when I right-click on the column. I have read that it is possible to sort on memo fields, but how?

Improve this question

1 Answer 1

Reset to default
1

You do it with Advanced Filter/Sort, but it's not very pretty (IMHO).

  1. Open your table in Datasheet view
  2. On the Home tab in the ribbon Click Advanced in the Sort & Filter group and select Advanced Filter/Sort.
  3. In the filter/query designer choose your memo field and select a sort order
  4. Click the Toggle Filter button up in the Sort & Filter ribbon group
Improve this answer
0

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .