Ok, do text fields store the same way, or do they always allocate the field
size whether it is used or not?

"Rick Brandt" wrote:

"AdmSteck" wrote in message
...
How much memory is needed to store memo fields? Would it be more efficient
to create a large text field?

In a memo field all that is stored in the table is a pointer to the actual data
stored elsewhere on disk (still within your file). The amount of space consumed
should be the amount of your data plus the small amount for the pointer. If you
need more than 255 characters then a Memo field is the appropriate choice.

The more "real" issue with Memo fields in Jet tables is that they can be prone
to corruption so you should be prudent with them. I usually ask my users if
they _really_ need more than 255 characters before I use them.


--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com