ACC2000: Help Incorrectly States Memo Column Cannot Be Sorted On

ID: Q217132

The information in this article applies to:
Novice: Requires knowledge of the user interface on single-user computers.


SYMPTOMS

The last bulleted item in the Microsoft Access Help topic "Considerations when sorting records in a table, query, form, or report" states the following:

"You can't sort a field whose data type is Memo, Hyperlink, or OLE Object."
This is incorrect.


STATUS

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


MORE INFORMATION

The ability to sort on Memo, Hyperlink or OLE Object fields is different depending on the Access object that contains the field you wish to sort. The following list describes the sorting behavior for each field type in each Access object described by the help file.

Ability to Sort on Field

Object Type Memo field Hyperlink field OLE Object field
Table No No No
Query Yes Yes No
Form No No No
Report Yes* Yes* No

* You can sort Access reports based on both Memo and Hyperlink fields in the Sorting and Grouping dialog box but you must type the name of the Meme or Hyperlink field into Field/Expression box since those fields will not show up in the list of available fields.

NOTE: Memo fields will only be sorted based on the first 255 characters.


REFERENCES

For additional information about sorting Memo columns, please see the following article in the Microsoft Knowledge Base:

Q217138 Sort Options Greyed Out for Memo Columns in Datasheets and Forms

Additional query words: pra 


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

Last Reviewed: June 24, 1999