max number of fields on a form (new question)

N

noe1818

I am creating a database based on a paper form. The paper form has over 360
individual pieces of information, all of which are recorded for research
purposes. My boss would like me to create a replica electronic form based on
the paper form, but access only allows 255 fields on one form. Other than
subforms, is there any other way to get around this? I have my data organized
into related tables, but every field from each table needs to be on the form.
Any suggestions?
 
K

Klatuu

The limit of 255 is not the form. Forms have a lifetime limit of 754
controls. That means that if you delete a control the count does not reduce
by 1, but when you add a control, the count is increased by 1.

The limit is the number of fields allowed in a table or query.

You might try using a subform for each table.
 
D

Douglas J. Steele

In addition to what Dave said, what's wrong with subforms, especially if you
want the form to be updatable?
 
L

Linq Adams via AccessMonster.com

And to continue, while the limit of 255 is not the form, it is the limit of
fields in a recordset, which means, I think, that you have to have subforms.
Since you're in the planning stages, you might want to take a look at this
site, which is a fairly good guide to programming a database for surveys.
 
G

Guest

Klatuu said:
The limit of 255 is not the form. Forms have a lifetime limit of 754
controls. That means that if you delete a control the count does not
reduce
by 1, but when you add a control, the count is increased by 1.
Click to expand...

Is that even if you compact the database?

Tom Lake
 
J

John W. Vinson

Is that even if you compact the database?
Click to expand...


Yes.

To get around it you must create a new form and copy and paste the controls
that you want to keep.

John W. Vinson [MVP]
 
Top