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