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

In this Microsoft Access tutorial you're going to learn all about using colors in your VBA. Talk about the access long color codes, hex colors, and the RGB function. I'll show you how to change the background color of a field in your Access forms.
LEARN MORE:
599cd.com/VBAC...
PRE-REQUISITES:
Intro to VBA: 599cd.com/Intr...
RECOMMENDED COURSES:
Access Developer 40: 599cd.com/ACD40
LINKS:
Color Picker: htmlcolorcodes...
Long to RGB: nolongerset.co...
BECOME A MEMBER:
KZbin: / @599cd
or My Site: 599cd.com/THMe...
FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: 599cd.com/THFree
Blank Template: 599cd.com/Blank
Contact Management: 599cd.com/Cont...
Order Entry & Invoicing: 599cd.com/Invo...
More Access Templates: 599cd.com/Acce...
ADDITIONAL RESOURCES:
FREE Access Beginner Level 1: 599cd.com/Free1
$1 Access Level 2: 599cd.com/1Dollar
Donate to my Tip Jar: 599cd.com/TipJar
Get on my Mailing List: 599cd.com/YTML
Contact Me: 599cd.com/Contact
TechHelp: 599cd.com/Tech...
Consulting Help: 599cd.com/DevNet
Twitter: / learningaccess
en.wikipedia.o...
products.offic...
microsoft.com/...
KEYWORDS:
access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, color, rgb, hex, access long colors, Microsoft Access Colors, rgb function

[@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.