Fields in a form?

J

JPS

What is the maximum number of fields that can be added to a form. I have
several tables which I need to show on one form but an error message tells me
that I have too many fields defined.
Would sub-forms help and if so, how do i do them.
Thanks
 
R

Rick B

Have you looked at the help files? They spell it all out.

The maximum is 255 over the lifetime of the form. That means that adding a
control, then later deleting it still counts. Compacting your database will
help with this issue.

To get around this, you can use subforms. Each subform can have 255
controls as well.
 
Top