Microsoft KB Archive/217138

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

Article ID: 217138

Article Last Modified on 6/24/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



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.



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.
 * 1) On the View menu, click Datasheet view.
 * 2) 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).

