ACCESS Table Column Sort Problem

[vanHel]

Hi.
I have a problem to sort a table by one column (sounds too easy, I know). I created the table by importing it from a text file. After the import I added a column (Memo format). I did not change any properties of the column or table.

Now it is impossible to sort the table by the column added after the import. Even in queries Access ignores sorting criterias for this column.

Does anybody know about this problem or has helpful hints?

Thanks in advance!
Robert

 

[Remou]

Hi vanHel
As far as I know, you can never sort on memo format fields in a table. Can you use a query? This works for me (SQL view):

SELECT Table.MemoField
FROM Table
ORDER BY Table.MemoField