Sorting table items

[George]

Good Day All,

I have a table with several fields. Sorting on the ID field and several other fields is working fine. However for some unknown reason there are about 3 field that are greyed out - not allowing sorting on them.



Can anyone explain this occurrence?

[CJ_London]

not enough info to answer. show your table detail and the field detail for the ones that are greyed out

[pbaldy]

If the data type of those fields is Memo, I don't think you can sort on them in the table.

[isladogs]

However, if these are memo fields, you can sort on them using a query.

[George]

Thanks for the responses.

The data type for the greyed out fields are Long Text.

Can this help?

[pbaldy]

Yes, same as memo, can't sort on in tables.

[George]

Thanks for the information.

I was able to convert to Short text and the problem was instantly resolved.

[CJ_London]

As you’ve discovered, long text is another name for memo fields