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

  • Thread starter Thread starter Guest
  • Start date Start date
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
 
You can see the list of specifications if you open Help from database window
and type Specification in the index.
 
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.
 
Back
Top