forms- is there a limit of fields on a form?

G

Guest

I was told that there was a limit of 255 fields per form but I did not see
that in the access specifications in the help file. It was suggested to me to
maximize the use of subforms to overcome that limitation.
True or false?
Thanks
 
K

Ken Snell [MVP]

You can see the list of specifications if you open Help from database window
and type Specification in the index.
 
A

Allen Browne

There is a limit of 255 fields in a table, but you can have more than 255
controls on a form, e.g. if 255 text boxes have attached labels, you already
have > 500 controls.
 

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

Access Access DB Form Limit Hit 0
Limit on number of fields in form 1
Combo Box Limit of 20 Fields 12
max number of fields on a form (new question) 5
Upsizing and Limit of number of fields 2
Forms and to many fields 5
Limit on number of fields in MS Access forms 3
Subform of subform not being linked 3

Top