A Memo can actually contain up to two gigabytes (though if you did that
there'd be no room for anything else in the database), if you populate the
One possible issue is that if you apply a Format to the memo field (whether in
the table properties, the query field properties, or the form/report textbox
properties); or if you try to sort the query by the memo field - you'll be
truncated to 255.
John W. Vinson [MVP]