Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Is there a size limit on a FOrm.?

Status
Not open for further replies.

Kjonnnn

IS-IT--Management
Jul 14, 2000
1,145
US
Is there a size limit on a FOrm.?
 
I'm not sure i this is what you want but the maximize size a form can be is 22" by 22". If its a specific control you would like to know about I think your limited to the max size of the form
 
That's good to know. I was thinking about a maximum number of fields included from other tables.
 
While there is no limit on the number of fields that a form can have, there is a limit of 754 controls over the life of a form and a limit of 255 fields in the output of a query. And yes, the form size limit is 22".

See "Access Specifications" in the on-line help for more numbers.

Jim.
 
Something better to think of. With those limits that Access has set, if you use them all on one form, I don't want to use or work on that application.

Make the form easy for both the end user to use and the next programmer to maintain by keeping the forms simple. Don't put 754 controls on one form just because you can. Either create multiple forms or one form, but use the TABS control to break up the data. Terry M. Hoey
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top