I would also like to be able to cope with controls on a subform.
I know how to refer to them generally:
SubformControlName.Form.Controls(i)
but can you suggest how they could be incorporated in your scheme?
TIA
By the way, I'm using your code to do (potentially) several different actions for a control.
For instance, I might want to change a textbox backcolor on GotFocus, but also change its entry to all uppercase on LostFocus.
I put a single letter in the tag for each type of action - H for Highlight...
Thanks! I'd already realised the Event vs OnEvent situation, and dealt with it elsewhere - but not there!
Many thanks for the prompt reply.
I'm at www.martynmathews.com
thread702-1462022
The above thread shows how to subclass various events within Access.
This is working fine for me, except for GotFocus and SetFocus events, which do not appear to be trapped.
In the CommonControl class module I have
mTextBox.OnGotFocus = "[Event Procedure]"...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.