How to Get the Exact Color You Want in Microsoft Access VBA

[@davidpopovich-qj6oh]

This video clears up a lot of confusion with colors. Thanks

[@599CD]

You’re welcome 😊

[@stephenbeswick2163]

Hi Richard excellent video about different colours grateful for this video. SteveB

[@599CD]

Glad you enjoyed it

[@hikmatmarashdeh2293]

excellent explanation and presentation as usual 👌👏

[@599CD]

Thanks a lot 😊

[@moodkn]

Thanks...! Helpful Exercise

[@599CD]

Most welcome!

[@luzkrg]

Interesting video 😃 Colors are a hassle for me in Access, trying not to repeat them for different forms, trying not to make the database look unprofessional or too colorful; trying for it to be easy on the eyes if using it for long periods of time, the list goes on 😂

[@599CD]

Thanks for sharing!

[@abdulhamidalhaddadi2255]

Great,
how can I change color based on subject value?
thank you in advance

[@599CD]

What do you mean?

[@abdulhamidalhaddadi2255]

@@599CD I will say it in other way.
your example change color by click button.
But what I want is: how can I change Note color to any color based on state or city?
Thank you in advance.

[@599CD]

Sure. You can either use conditional formatting or an AfterUpdate event for a single form. Search my channel for videos on both.

[@robert8422]

AWESOME Bob W.D.C.

[@599CD]

Thanks

[@vitom5513]

Thanks for deleting the comment. I know it worked on a much older version of Access but when I just tried to open that database, it didn't. I should have checked before I posted. Sorry.

[@599CD]

I don't remember deleting any comments.