Richard,
I did not want to bother you so often, but I posted the following on another forum and have not received any help.

I am building a database that has several forms with several textboxes on each form. I would like to provide my users with some visual aid as to where in the form they are, without having to search for the blinking cursor. I would like all my textboxes on all my forms to have a default backcolor which changes to another color when they receive focus and changes back to the default backcolor when focus is lost. At the moment, I am coding for the GotFocus and LostFocus for each textbox, but this is a pain, having so many textboxes.
Can you help me with a public function, or suggest another method to accomplish this? I really don't want to write the same code over and over again for every textbox on all my forms.
Thanks in advance for your help.
Rupert

---

Reply from Richard Rost:

You can create a public function to handle the actual color change, but you'll STILL have to put that function call in each of those two events for EVERY text box. I know... it's a pain... but even I don't know of any other way around it. I feel your pain... I've done something similar to this in the past myself.

You could write some VB code to actually write the rest of the VB code for you. It's POSSIBLE, and I've done it before, but I'd have to do some research to figure out how to do it again. :)

If anyone else has any ideas, I'd love to hear them.