Limit on number of fields in MS Access forms

  • Thread starter Thread starter xxx g
  • Start date Start date
X

xxx g

Hi,

I'm trying to create a form for a table that has 80 fields and I
receive the below error message.

"The number of fields from your currently selected table or query
exceeds the maximum height in Microsoft Office Access forms."

Is there a limit on how many fields a form can have or on the size of
the form?
If so, what are my options to create a form from this table.

I appreciate your responses.

Thanks.
 
xxx said:
Hi,

I'm trying to create a form for a table that has 80 fields and I
receive the below error message.

"The number of fields from your currently selected table or query
exceeds the maximum height in Microsoft Office Access forms."

Is there a limit on how many fields a form can have or on the size of
the form?
If so, what are my options to create a form from this table.

I appreciate your responses.

Thanks.
Click to expand...

Sounds to me like you are building the form with the wizard. If so you have
hit a limit of the wizard, not of forms generally. It likely wants to stack
the controls vertically and has hit the 22 inch section height limit. Do it
yourself and you can arrange the controls so that is not an issue.
 
Sounds to me like you are building the form with the wizard.  If so youhave
hit a limit of the wizard, not of forms generally. It likely wants to stack
the controls vertically and has hit the 22 inch section height limit.  Do it
yourself and you can arrange the controls so that is not an issue.
Click to expand...

Thanks for the response. That worked.
 
I'm trying to create a form for a table that has 80 fields and I
receive the below error message.

"The number of fields from your currently selected table or query
exceeds the maximum height in Microsoft Office Access forms."

Is there a limit on how many fields a form can have or on the size of
the form?
If so, what are my options to create a form from this table.
Click to expand...

I see Rick has already given you an answer that works.

Also consider using the tab control to group similar fields together
so things aren't quite so crowded for the user.

Also note that you can drag and drop multiple controls from the form's
field list to the form.

Tony
--
Tony Toews, Microsoft Access MVP
Tony's Main MS Access pages - http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
For a convenient utility to keep your users FEs and other files
updated see http://www.autofeupdater.com/
 
Back
Top