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

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Drew Arnold

    Limit to the Number of Rows in a Table???

    Drew Arnold, Mar 5, 2004, in forum: Access Table Design
    Replies:
    6
    Views:
    75
    Douglas J. Steele
    Mar 7, 2004
  2. Vernon

    Limit Number of Records

    Vernon, Aug 2, 2004, in forum: Access Table Design
    Replies:
    3
    Views:
    126
    John Vinson
    Aug 2, 2004
  3. anomynous

    How to limit the digit in number data type field

    anomynous, Sep 8, 2004, in forum: Access Table Design
    Replies:
    2
    Views:
    78
    Tim Ferguson
    Sep 8, 2004
  4. nathan a

    Limit Auto Number

    nathan a, May 26, 2005, in forum: Access Table Design
    Replies:
    5
    Views:
    102
    nathan a
    May 26, 2005
  5. blackcat

    exceed limit of 255 fields

    blackcat, Oct 18, 2005, in forum: Access Table Design
    Replies:
    18
    Views:
    169
    Bernard Piette
    Dec 20, 2005
  6. Steve

    Limit Number of Records in a table

    Steve, Nov 28, 2005, in forum: Access Table Design
    Replies:
    3
    Views:
    64
    mnature
    Nov 28, 2005
  7. jiaozp

    Limit on number of tables?

    jiaozp, Apr 19, 2006, in forum: Access Table Design
    Replies:
    3
    Views:
    73
    John Vinson
    Apr 19, 2006
  8. RRKEM via AccessMonster.com

    2GB limit - Will it be true for a db with large number of images?

    RRKEM via AccessMonster.com, Aug 24, 2006, in forum: Access Table Design
    Replies:
    8
    Views:
    119
    Stephen Lebans
    Aug 25, 2006
Loading...