ACC2000: Sort Options Dimmed for Memo Columns in Datasheets and Forms

ID: Q217138

The information in this article applies to:

SYMPTOMS

In Microsoft Access 2000, you can sort on Memo fields in a query. However, if you select a Memo field in a datasheet or on a form, you will not be able to sort by this field.


RESOLUTION

Create a query that includes the Memo column, and then apply the sort that you want.


STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.


MORE INFORMATION

Steps to Reproduce Behavior

  1. Open the sample database Northwind.


  2. Open the Categories table in Design view.

    Note that the data type for the Description field is Memo.


  3. On the View menu, click Datasheet view.


  4. Click the Description column and then right-click the column to display the shortcut menu.


Note that the menu choices for Sort Ascending and Sort Descending are unavailable (dimmed).


REFERENCES

For more information about sorting on Memo fields, please see the following article in the Microsoft Knowledge Base:

Q217132 On-line Help Incorrectly States Memo Column Cannot Be Sorted

Additional query words: pra 


Keywords          : kbdta 
Version           : WINDOWS:2000
Platform          : WINDOWS 
Issue type        : kbbug

Last Reviewed: May 13, 1999