[AccessD] Form Lifetime Control Limit (Was: Advice on A2010....)

Kenneth Ismert kismert at gmail.com
Wed Dec 14 17:10:38 CST 2011


Try this:

1. Use TestControlLifetimeLimit() to fully populate a form.

2. Save as "Form1"

3. Delete the FIRST 400 controls.

4. Run TestControlLifetimeLimit(Forms(0)). Note that it can't add any more
controls.

5. Close the form. Run these commands:
     application.saveastext acForm, "Form1", currentproject.Path & "\" &
"Form_Form1"
     application.loadfromtext acForm, "Form1", currentproject.Path & "\" &
"Form_Form1"

6. Design the form. Run TestControlLifetimeLimit(Forms(0)).

Here I predict two things:
A. This will fail for Access 97 forms, even those imported into a later
version of Access. This is the classical 'lifetime limit' error.
B. This will succeed for forms created in A2K or later.

So, for the authors of EatBloat, I would modify their documentation to say:

For Forms & Reports created in Access 2000 or later:
> SaveAsText/LoadFromText will reset the control count, allowing you to add
> more controls up to the version control limit.
> For Forms & Reports created in Access 97 or earlier:
> SaveAsText/LoadFromText will NOT reset the control count. You must edit the
> ItemSuffix attribute in the text file (and possibly rename controls) to
> reset the control count. This behavior will persist, even if the form is
> imported into a later version of Access.
>

-Ken



More information about the AccessD mailing list