Conditional Formatting Value =""

[D Willett]

Hi.
I can use the following "Expression Is": IsNull([LastWorkCat])=True in Conditional Formatting, but I need the expression to test for an empty field value where the value is ""
Can someone help with the syntax here?

Kind Regards

[HansV]

Try

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

This will catch both Null and the empty string "".

[D Willett]

Great stuff Hans. Works a treat.

Regards