Hi everyone,
I found this older thread Change font color on ALL form controls on "Got Focus" and "Lost Focus" where ChrisO provided a pretty good solution.
The only downsides I came across:
1) This procedure overwrites your current code on Got Focus and Lost Focus events if you have any
2) I didn't manage to make it work on subforms
Regarding the first downside I was wondering if there is a way to capture the code on Got Focus and Lost Focus before entering into Chris' procedure?
Meaning to keep the current code I have there and just add the Got Focus and Lost Focus code from Chirs' procedure. I wonder if there is a way, with the research I did I wasn't quite successful.
As for the second downside I could't make it work on the subforms when I run the main form with them. If I open the subform alone it works.
Hope there are some ideas.
Thanks!
I found this older thread Change font color on ALL form controls on "Got Focus" and "Lost Focus" where ChrisO provided a pretty good solution.
The only downsides I came across:
1) This procedure overwrites your current code on Got Focus and Lost Focus events if you have any
2) I didn't manage to make it work on subforms
Regarding the first downside I was wondering if there is a way to capture the code on Got Focus and Lost Focus before entering into Chris' procedure?
Meaning to keep the current code I have there and just add the Got Focus and Lost Focus code from Chirs' procedure. I wonder if there is a way, with the research I did I wasn't quite successful.
As for the second downside I could't make it work on the subforms when I run the main form with them. If I open the subform alone it works.
Hope there are some ideas.
Thanks!
Last edited: