"Linq Adams via AccessMonster.com" u28780@uwe wrote in message
news:8366bcf1e78c0@uwe...
If you have too many text fields with 255 characters in them, (that means
if users input 255 characters in too many textboxes in the form) all in
the same record, you will run into the limit for a single record.

I wasn't aware that there was a "limit" for a single record. Exactly what
is
that limit?

I can never remember whether it's 2000 or 4000 bytes.

Easy enough to write a test to determine, though. Create a table with, say,
20 fields defined as Text(255).

Start writing records to the table, adding a character for each record,
until you can't write anymore.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)