Limit on number of fields in MS Access forms


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

Advertisements

R

Rick Brandt

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.

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

xxx g

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.

Thanks for the response. That worked.
 
Ad

Advertisements

T

Tony Toews

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 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/
 

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

Top