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

[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

 

[Ken Snell [MVP]]

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

 

[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.

 

[Guest]

Thanks Allen,
I appreciate the info.
Doug Lazenby