max number of fields on a form (new question)

[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?

 

[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.

 

[Douglas J. Steele]

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

 

[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.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Message posted via AccessMonster.com

 

[Guest]

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.

Is that even if you compact the database?

Tom Lake

 

[John W. Vinson]

Is that even if you compact the database?

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]