Volume Limits

[Guest]

I have a form that was built to import an excel spreadsheet and look like the
spreadsheet for the users. They recently added a few more items to the
spreadsheet and now if all the fields a filled in I get the "Record Is Too
Large" message.

How many bytes/Characters can you put on a form?

 

[John Vinson]

I have a form that was built to import an excel spreadsheet and look like the
spreadsheet for the users. They recently added a few more items to the
spreadsheet and now if all the fields a filled in I get the "Record Is Too
Large" message.

How many bytes/Characters can you put on a form?

Multiple gigabytes... *on a Form*.

However, data is not stored in forms. Data is stored in Tables. Any
single record in a Table is limited to 2000 characters (4000 Unicode
bytes in A2000 and later); memo fields are not subject to this
limitation. But if you have a Table with so many text fields that
you're exceeding the 2000 character limit, you are "committing
spreadsheet upon a database", and probably have a seriously
non-normalized table design.


John W. Vinson[MVP]

 

[Guest]

I am commiting intentional Spreadsheet. That is exactly what the user wants
to see. I pull the data from a spreadsheet onto a form, with an underlying
table, and then once I have the spread loaded into the table I then pick off
the info I need. Given the 2000 character limit I guess I will need to split
the table.

 

[John Vinson]

I am commiting intentional Spreadsheet. That is exactly what the user wants
to see. I pull the data from a spreadsheet onto a form, with an underlying
table, and then once I have the spread loaded into the table I then pick off
the info I need. Given the 2000 character limit I guess I will need to split
the table.

Ouch! My sympathies. Yes, you'll either need to split the table into
two with a one-to-one relationship - bearing in mind that the 2000
character limit applies to queries, too - or use an unbound Form with
VBA code to populate the table.

John W. Vinson[MVP]