Fields in a form?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
Back
Top