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
Conditional Formatting Value =""
-
- SilverLounger
- Posts: 1728
- Joined: 25 Jan 2010, 08:34
- Location: Stoke on Trent - Staffordshire - England
Conditional Formatting Value =""
Cheers ...
Dave.
Dave.
-
- Administrator
- Posts: 78535
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Conditional Formatting Value =""
Try
Nz([LastWorkCat],"")=""
This will catch both Null and the empty string "".
Nz([LastWorkCat],"")=""
This will catch both Null and the empty string "".
Best wishes,
Hans
Hans
-
- SilverLounger
- Posts: 1728
- Joined: 25 Jan 2010, 08:34
- Location: Stoke on Trent - Staffordshire - England