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

P

PitBullBlonde

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?
 
Top