On Tue, 29 Apr 2008 12:07:32 GMT, "Linq Adams via AccessMonster.com"
u28780@uwe wrote:

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?

From Help... Specifications:

Number of characters in a record (excluding Memo and OLE Object fields) when
the UnicodeCompression property of the fields is set to Yes: 4,000

Interesting that it's not 4095 or 4096 or some other power of two!

It's a rather nasty limitation, because you can easily create a table with
multiple text fields; it will work fine initially, and you can go for months
until someone with a verbose streak actually USES all 25 of the 255-byte text
fields.
--

John W. Vinson [MVP]