sort records by size of items in memo field, or pull those > 255 s

I just created tables, but took errors because 3 fields had text too large
for the text field (255). I re-created the tables using memo instead of text
for the field, and now I would like to go back to these new tables and find
the records that were too big for the text field (255 in size) - how to do
it based on the size of the items in the memo field - can I do a query of all
records where that field is greater than 255 char, or can I sort the table in
ascending or decending order based in the item size in that field - or are
all the those fields the same size now?

-----Original Message-----
I just created tables, but took errors because 3 fields
had text too large
for the text field (255). I re-created the tables using
memo instead of text
for the field, and now I would like to go back to these
new tables and find
the records that were too big for the text field (255 in
size) - how to do
it based on the size of the items in the memo field - can
I do a query of all
records where that field is greater than 255 char, or can
I sort the table in
ascending or decending order based in the item size in
that field - or are
all the those fields the same size now?
.

This is it in query design.

nameofqueryfield: len([memo])

You can sort it like any other field in query design.

Hope this helps

Martin