Create Colored Data Bars in Microsoft Access Combining Data Bars with Color Scales

In today's Microsoft Access tutorial, I'm going to teach you how to create Colored Data Bars, which are a mix between regular data bars and color scales that you can build in Microsoft Excel with conditional formatting. We're going to learn how to do that today in Access, which isn't something you can easily do in Excel.
Silver Members & up get access to an Extended Cut of this video. Members will learn how to enhance their color data bars so that they can work with any scale of values instead of just one to 100.
MEMBERS-ONLY EXTENDED CUT VIDEO:
• Create Colored Data Ba...
BECOME A MEMBER:
TH-cam: / @599cd
or My Site: 599cd.com/THMember
LEARN MORE:
Colored Data Bars: 599cd.com/ColoredDataBars
PREREQUISITES:
Data Bars: 599cd.com/DataBars
Color Scales: 599cd.com/ColorScales
LINKS:
Expression Is: 599cd.com/ExpressionIs
NZ Function: 599cd.com/NZ
Progress Bar: 599cd.com/ProgressBar
COLORED DATA BARS SERIES:
Data Bars: 599cd.com/DataBars
Color Scales: 599cd.com/ColorScales
Colored Data Bars: 599cd.com/ColoredDataBars
FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: 599cd.com/THFree
Blank Template: 599cd.com/Blank
Contact Management: 599cd.com/Contacts
Order Entry & Invoicing: 599cd.com/Invoicing
More Access Templates: 599cd.com/AccessTemplates
ADDITIONAL RESOURCES:
FREE Access Beginner Level 1: 599cd.com/Free1
How to Use Access in 30 Minutes: 599cd.com/30Minutes
$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/TechHelp
Consulting Help: 599cd.com/DevNet
Twitter: / learningaccess
en.wikipedia.org/wiki/Microso...
products.office.com/en-us/access
microsoft.com/en-us/microsoft...
KEYWORDS:
TechHelp Access 2016, Access 2019, Access 2021, Access 365, Microsoft Access, MS Access, MS Access Tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, create colored data bars, conditional formatting access, access data visualization, color scales Access, Excel-like formatting Access, custom data bars Access, Access tutorial, visual data representation, Access conditional formatting, Access database design, advanced Access features, Access design tips, Access form design, graphical data Access, Access form customization, enhance Access forms
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.
Live long, and prosper.

[@user-fu1ee4kz5m]

That trick usuing the Alt key to select an ASCII character is great! I'd never seen that before! Thank you.

[@599CD]

That one's been around forever glad to learned something new

[@lawrenceayanful6204]

Thank you Richard... God bless you

[@599CD]

Welcome!

[@easyspeak101]

Thank you Richard.. awesome.

[@599CD]

Glad you liked it

[@Shadow.Dragon]

Another great video!!! I did not know (or had forgotten...) about the string function. LOL!!!

[@599CD]

Glad you enjoyed it!

[@donaldshroyer8633]

Another interesting and informative series. Well done!

[@599CD]

Glad you enjoyed it!

[@lawrenceayanful6204]

Have been waiting all day..😊

[@599CD]

Enjoy

[@xavierbatlle1828]

Smart and easy trick to achieve it! 😉

[@599CD]

Indeed!

[@gonefishing2006]

Loved this one.... buuuuutttttt I had to watch the extended *Like* 3 times before the whole thing clicked.

[@janvanantwerp6574]

Tks. This will replace a "chart" as a "quick" preview of some stuff!. How about a 2 colour bar?

[@599CD]

That would be tricky

[@BDCDT-NguyenMinhQuang]

Absolute amazing video
I noticed in all of your video, your's go to font is always Calibri (not a bad choice though)
I'm also mainly use Calibri in my form but it looks choppy and some part even heavily pixelated (the other font even worse)
I thought maybe becaused of my form used a lot of Unicode character, but it happened even when I removed all of that characters
I updated my M365 to the newest version but all the font that I can use in MS Access appication is still the same
I wonder if I can use modern font to give my form a diffrent look, it's great if it's a font supported by MS then I don't have to manualy install 3rd party font in my client laptop
Tks in advance

[@599CD]

I like Calibri and Tahoma. :)

[@tutsecret499]

What if I want to know how many projects were distributed to each employee almost equally. Example: From 500 projects I assign 100 projects for employee A; 50 for employee B, and the remainder I assign to more other 4 employees. So should I create on the query and on the form the =Count employee A, Count for B, and so forth to get the bar to visualize if employee A or B, etc is not overwhelmed with number of projects and then I would do the reassignment for employee that has less projects? After doing so many assignments in a daily basis, you lose track who has more or less projects, so the data bar would help

[@599CD]

599cd.com/ask