On Fri, 19 Nov 2004 08:15:05 -0800, "AdmSteck"
wrote:

How much memory is needed to store memo fields? Would it be more efficient
to create a large text field?

A Text field is limited to 255 bytes, so there's no such thing as a
"large text field". A Memo stores as many characters as are entered
into the field, plus a 16-byte overhead no matter the size of the memo
field. Thus if you have 40 bytes in the memo field, it will take up 56
bytes on disk; if you have 40,000 bytes, it will take up 40,016 bytes.

If you don't need more than 255 bytes, use Text; text fields are more
efficient, they can be indexed, and they're less subject to corruption
than Memos.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps