ACC2000: Help Incorrectly States Memo Column Cannot Be Sorted On

ID: Q217132

The information in this article applies to:

Microsoft Access 2000

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 URL URLs

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