Results 1 to 2 of 2

Thread: Max fields

  1. #1
    Star Lounger
    Join Date
    Dec 2000
    Location
    Tacoma, Washington, USA
    Posts
    68
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Max fields

    What is the maximum number of fields that can be placed on an Access 2000 form. Is this more or less than for 97?
    I have a user that was going back and forth between 97 and 2000, designing a simple (but large) form. The db has now been corrupted, somehow. The form can be opened in its 2000 incarnation, but will not open in 97. The other objects still work.
    <IMG SRC=http://www.wopr.com/w3tuserpics/DougKlippert_sig.jpg>

  2. #2
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Indianapolis, Indiana, USA
    Posts
    1,862
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Max fields

    I'm fairly certain that the limit for objects on an Access 2000 form is 720. I believe it's slightly less in Access 97 (652 or something like that). I have a project where I need to have over 1200 objects on a form, but I'm forced to use subforms instead. (It's a LONG story[img]/w3timages/icons/yikes.gif[/img]!)

    As for number of fields, I believe it's the same for Access 97 and 2000.

    One thing that has helped me in the past is to select all objects on a form, copy, and paste into a new form. There's the headache of resetting the form properties and copying the code, but it can sometimes fix things when using so many objects on a form.

    Hope this helps
    -MarkJ-

Posting Permissions

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