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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Separate Form 0
Use field to update multiple fields 4
Data entry for a table from a form 2
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Form Problem 0
Access Form - Lock Fields from Editing 0
Access Form Refresh 1
Access Passing data from a form to another form! 0

Back
Top