Limit on number of fields in MS Access forms

Discussion in 'Access Table Design' started by xxx g, Dec 22, 2010.

  1. xxx g

    xxx g Guest

    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 g, Dec 22, 2010
    #1
    1. Advertisements

  2. xxx g

    Rick Brandt Guest

    xxx g wrote:

    > 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.
     
    Rick Brandt, Dec 22, 2010
    #2
    1. Advertisements

  3. xxx g

    xxx g Guest

    On Dec 22, 1:18 pm, Rick Brandt <> wrote:
    > xxx g wrote:
    > > 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 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.
     
    xxx g, Dec 22, 2010
    #3
  4. xxx g

    Tony Toews Guest

    On Wed, 22 Dec 2010 07:40:06 -0800 (PST), xxx g <>
    wrote:

    >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/
     
    Tony Toews, Dec 23, 2010
    #4
    1. Advertisements

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 (here). After that, you can post your question and our members will help you out.