Results 1 to 6 of 6
  1. #1
    Star Lounger
    Join Date
    Mar 2001
    Location
    Michigan, USA
    Posts
    62
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Report Wizard field limit? (Access 2000)

    Can someone tell me what this message means: "The wizard is unable to create your form or report because you chose too many fields; please try again with fewer fields."? Is there a limit to the number of field that can be used? If so, what's the limit?

  2. #2
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Mishawaka, Indiana, USA
    Posts
    145
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report Wizard field limit? (Access 2000)

    In Access 97 you can read about the specifications in the help index.

    Specifications
    Microsoft Access
    Microsoft Access Specifications
    Read about table specifications

    The max number of fields in A97 is 255.

  3. #3
    New Lounger
    Join Date
    Apr 2002
    Location
    Columbus, Ohio, USA
    Posts
    19
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report Wizard field limit? (Access 2000)

    Paula: From Access 2000 help, keyword was specification - number of controls over the lifetime of a form or report is 754. If you have that many, WOW! 255 is the number of fields in a table or recordset. You may want to check these also.

  4. #4
    Star Lounger
    Join Date
    Mar 2001
    Location
    Michigan, USA
    Posts
    62
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report Wizard field limit? (Access 2000)

    The database only has around 60 fields, so that's obviously not the problem. This database has been amended several times already, so we must have something corrupted in it. We'll probably end up re-creating it. Glad we're still at the start-up stage.

  5. #5
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Report Wizard field limit? (Access 2000)

    Before you re-create the database, try compact and repair.
    If this don't work, try Jet Compact Utility Available in Download Center
    And if this also don't work, create a new empty database and import all the object from the old one.

    HTH
    Francois

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Report Wizard field limit? (Access 2000)

    It may just be that the report becomes too complex for the wizard to handle. The wizard tries to assign control widths according to the size of the underlying fields. The maximum width of a report is 22 inches (55 cm). If the combined widths of the controls exceeds 22 inches (or the page width, if you specify that the wizard must fit everyting onto the page), the wizard must try to reduce the widths. I suppose this may prove too complicated if the number of fields is large (but well below th theoretical maximum of 255).

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •