[AccessD] Form Lifetime Control Limit -- Final Recommendation

Kenneth Ismert kismert at gmail.com
Fri Dec 16 10:14:07 CST 2011


>
> William Benson:
> Control name property is read only in runtime right? So for ac97 this a
> manual find and rename operation?
>

You're correct, name is a design-time property.

You can fairly easily write code to rename controls with the form in design
view. For the purposes of Lifetime Control Limits, the names don't even
have to be meaningful, just different from the defaults.

But this code would have to:
 * Rename control references and event handlers in the form's module
 * Find and fix all control references in form and control property
expressions, as well as in underlying queries.
 * Find and fix control references in queries, forms, reports, macros and
modules outside of the form in question.

So, if you have to maintain a monster form that was created in A97, and are
running into control limit issues, the task of fixing it could be huge.

If that is the case, maybe its time to start from scratch with a simpler
solution that spreads functionality among a number of smaller forms.

-Ken



More information about the AccessD mailing list