Conditional Formatting on a NULL Value in Microsoft Access - IsNull, Blank Entries, Missing Data

In this video I'll show you how to use an expression to use conditional formatting to highlight Null values.
LEVEL: Upper Beginner (IsNull Function)
Madison from Cleveland, Ohio (a Gold Member) asks: I'm trying to use conditional formatting to highlight fields that are missing values, but it's not working. I've tried putting Null, Is Null, =Null, and a bunch of other values in, but nothing works. Help?
BONUS FOR CHANNEL MEMBERS:
Silver Members and up get access to an EXTENDED CUT of this video. I'll show you how to make that conditional format NOT apply to the new blank row on the bottom of the form.
MEMBERS ONLY VIDEO:
• Conditional Formatting...
BECOME A MEMBER:
/ @599cd
LINKS:
Continuous Forms: 599cd.com/Continuous
Conditional Formatting: 599cd.com/conditional
Conditional Formatting with Expressions: 599cd.com/D1B3N
Conditional Formatting Show Duplicates: 599cd.com/1444
Checklists (Also Covers Nulls): 599cd.com/1447
ADDITIONAL RESOURCES:
Get on my Mailing List: 599cd.com/YTML
FREE Access Beginner Level 1: 599cd.com/Free1
FREE Blank Customer Template: 599cd.com/FRL2
$1 Access Level 2: 599cd.com/1Dollar
TechHelp: 599cd.com/TechHelp
Twitter: / learningaccess
en.wikipedia.org/wiki/Microso...
products.office.com/en-us/access
microsoft.com/en-us/microsoft...
Email Me: [e-mail]
WHAT DOES LEVEL MEAN:
My Access classes are divided into multiple levels. BEGINNER requires little working knowledge of Access. EXPERT assumes you know relationships and how to use functions and action queries. ADVANCED users know macros and events. DEVELOPER uses SQL and/or VBA programming.
KEYWORDS:
microsoft access, ms access, #msaccess, #microsoftaccess, conditional formatting nulls, conditional format nulls, conditional format null values, isnull, blank values, missing values, missing data
QUESTIONS:
Please feel free to post your questions or comments below. Thanks.

[@shaneeckel9549]

Very good! Perfect amount of depth on the subject. It can be very difficult to stay on point when you are showing various options (say, explaining when IsNull() or =IsNull works in an Expression compared to just a common Cond. Formatting... condition field), but you handled it just right, while still 'mentioning' there's an alternate scenario when you'd do Y instead of X, yet not doing a deep-dive. I give sw training tutorials and this is always difficult for me and my video ends up being 15+ minutes - describing how to pull out the power cable from the wall outlet. Regardless, nice work and keep them coming. I love Access and don't want it to die!

[@599CD]

Thanks for the kind words. It's a difficult line to walk sometimes. I know a lot of times while I'm showing something that people have "well, what about...?" questions in their heads. So I want to at least mention that it's possible and yes, it will be covered in a future class. Then I get other people complaining that I'm just teasing them and not showing how to do it, just to sell more lessons. Nothing could be further from the truth, but I have to present the information in bite-sized chunks that you can digest in one sitting. You can't cram 4 years of medical school into the first semester. I can't show EVERYTHING there is to know about Form design in one 20-minute lesson! :)

[@kensimba7868]

Thanks Richard Rost for this free videos

[@599CD]

You are very welcome. :)

[@gregorytaylor2749]

Thanks for a fantastic video!

[@599CD]

You're welcome.

[@captainkeyboard1007]

This is a nice tutorial. I like the way you master Access 2016. I have Access 2019. I am learning well from this fine video.

[@599CD]

I'm glad you like it. 2016 and 2019 are almost identical.

[@gregorywilson3715]

@@599CD How do I become a member? Also, do you offer the option to ask questions?

[@599CD]

You click the JOIN button on KZbin or visit my site at 599cd.com/THM. You can always ASK your questions, however there's no guarantee for answers. If I've covered that topic already, I'll point you to the right video. If I haven't, and I like your question, I may make a video out of it.

[@captainkeyboard1007]

@@599CDZone I believe your last reply was for Gregory Wilson, who asked the last question in his comment. Probably, he happened to reply to my comment. Thank you for tapping or typing to me.

[@captainkeyboard1007]

@@599CD Thank you for tapping or typing to me.

[@petersalibi9246]

Thank you sir, very helpfull.

[@599CD]

Welcome

[@shooter505]

Hi, I'm trying to do this in a report and can't seem to make it work. Any suggestions? Thanks!

[@599CD]

Should work the same as in a form.

[@satyabanukil779]

Sir, I have a report with a currency field. I want to make it invisible where the value is zero. Is it possible? Kindly help.

[@599CD]

Sure... just use an OnCurrent event to set the visible property. 599cd.com/OnCurrent

[@anthonygonzales7718]

Q1.This only work on datasheet? Tried it on continuous form and didn't function. Q2. What if i want the opposite? Say, I want a textbox to be highlighted yellow when something IS entered into a textbox. That way when its printed it grabs the readers attention and when its empty to just stay white so no attention is drawn to the textbox.

[@599CD]

It should work in a continuous form. That's what I show in the video. If you want the opposite, then just change the conditions.

[@ShivkumarYadav-qv8lt]

Hi Kindly help me to fill empty or null cells will with a text

[@599CD]

What kind of text?

[@ahmedhasan505]

OK thanks ihave rule (fild1 not between fild2 and fild3) but it work write with some record and wrong with another whyyyyy!!!!!

[@599CD]

Impossible to tell from here.