Changing Textbox Colors

[Rupert Bennett]

Hello Everyone,
I have what I hope is a simple question. It is always tough when you don't know how.

I would like to change the textbox Backcolor when they have focus and when they have lost focus. I have something that works now, but it is a tedious exercise when you need to make changes and you have many textboxes.
I have in each textbox GotFocus Event e.g. Text1.BackColor = RGB(117,225,257)
and iin the LostFocus Event Text1.BackColor = RGB(225,225,0)

Can you give me some code , Global or at the Form level, that will do this for each textbox on the form? This would be a lot more effecient.
Thanks for helping.
Rupert

 

[Micron]

Options -
post a link to where you found the file
you have a Google account? Then you have a drop box there to which you can post a link to the file
We've never been allowed to post files here for as long as I've been lurking herein.

 

[welshgasman]

I haver also asked in another forum I frequent and this is the thread.

Solved - Simple textbox class?

This is mainly directed at @MajP as he seems to post the most about classes here, but would welcome input from anyone who creates their own classes. If I wanted to create a very simple textbox class and let us say I just want to use it to have common code run on GotFocus and LostFocus, so as to...

www.access-programmers.co.uk

@Micron I had to join the Access User Group to get a link to the file.
I have now uploaded it to my Google drive and here is the link

 

[welshgasman]

Seems I misunderstood some of what you are asking when talking in the other forum.
The easiest simple method would be to use a common public function and put that in the events

=GotFocusBackcolor()
or =LostFocusBackColor()

and have the relevant code snippet in in those functions.

 

[Rupert Bennett]

I found that this can be done without the need for any VBA code at all. You just need to assign the textbox the color you need it to show when it has focus and then set the BackStyle to Transparent. This works well , particularly if the form has a light colored backgrould. With a dark background form, Conditional Formatting works perfectly. I got this tip from a video by Karl Donaubauer on his site at Isladogs on Access I hope I am not violating any forum rules by listing this site. It has been many years since my last post.

 

[welshgasman]

That is not his site, but isladogs.
However if you have a solution, that is all that matters.
Care to provide the actual link?