Apply Conditional Formatting to blank controls on Form

[brharrii]

Access 2010.

I just discovered that Access allows conditional formatting on forms! I'd like to apply conditional formatting to 2 controls when their values are blank / null. I'm having troubles figuring out how to do this. I've messed around with it quite a bit and am just not getting it. This is what I've tried:




Field Value is Equal to: "", Null

Expression is: [FieldName]="", [FieldName]=Null, [FieldName] is NULL

Expression is: Len([FieldName])="", Len([FieldName])=Null, Len([FieldName]) Is Null

If anyone could clue me in to what I need to do I would be most appreciative

Thanks

[pbaldy]

How about

Nz([FieldName], "") = ""

[brharrii]

Bingo! Thanks as always pbaldy!

[pbaldy]

Happy to help!