Datasheet view (Sort disabled)

[DonK]

While viewing a form in Datasheet view and I right click the column header, some of the fields allow Sort Ascending and Sort Descending but other fields have the Sort options disabled. The data source is a single table.

Can someone explain the conditions that the cause the Sort option to be enabled or disabled when in Datasheet view?

 

[Liv Manto]

Is it an ole object?

From Access Clip:

You can't sort an OLE Object under any circumstances. Although you can't sort a Memo or Hyperlink field in a Page, you can sort these fields in a table, query, form, or report. In a report, you must type the name of the Memo or Hyperlink field into the Field/Expression box of the Sorting and Grouping dialog box because those fields don't show up in the list of available fields.

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

 

[trucktime]

Sort

I think you can only sort bound fields, unbound won't do it.

 

[DonK]

Field is "Locked"

The fields are all bound to the same table.

While in datasheet view, I believe the reason I am unable to sort some of the fields is that those fields have the "Locked" property.

 

[Liv Manto]

Really? What version of Access are you using?

 

[DonK]

Field is Not "Enabled"

I'm using Access 97.

I've found my problem. The sort is disabled when the field's "Enabled" property is set to "No".

 

[DonK]

More to the story

There's more to this story.

The sort will be allowed when the field property is "Enabled = Yes" and "Tab Stop = Yes".

 

[rockman]

Thanks for contributing DonK.

I had exactly the same problem and your solution listed above was just the ticket!

Jeff