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


The information in this article applies to:

  • Microsoft Access 2000
This article was previously published under Q217138

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 that this is a problem in the Microsoft products that are 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:

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

Modification Type:MajorLast Reviewed:6/24/2004
Keywords:kbbug kbnofix KB217138
©2004 Microsoft Corporation. All rights reserved.