How can I use 400 fields in MS-Access form?
As I understand it, the maximum number of fields on an MS-Access form is 255. Is there a way to get around this limitation?
I am working with a mental health survey form which contains about 400 fields.
I would like to create 1 data entry form to allow the mental health interviewer to enter all the answers in one form.
I plan to use tabs to make it easier to navigate through data entry.
The maximum number of fields in an Access record source is 255, as is the case with any SQL SQL statement. The limit on the number of controls on a form is 754 over its lifetime (i.e., removing a control gives you no additional control).
The design is clearly not correct, but, as is often the case, we cannot choose from this!
In this case, the only solution I can think of is a main form that has one field, PK, and then a bunch of subforms with subsets of fields, for example 100 each. This means that you must be very careful to make sure that your downstream record saves its changes to its OnExit event (otherwise you will run into write conflicts).
And no, this is not a very good design.
But this is at least a workaround if you are forced to have 400 fields because you have an external data source that you cannot normalize normally.
source to share