AMENDMENT to my Conditional Formatting Question

[Erin]

Okay, so I figured out how to have a field be highlighted if it doesn't equal
another field.... but what do I do if the field is blank? For instance...

Field 1 Field 2
Verbal Warning

If I want to highlight both these fields because they do not equal, how do I
do that? Currently, my conditional formatting does not highlight either field
in this situation.

Thanks!!!

 

[John Spencer]

Try using an expression - either one of the following should work.

Expression is
Nz([Field1],"") <> NZ([Field2],"")

OR

Expression is
[Field1] & "" <> [Field2] & ""


John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

 

[Erin]

Worked PERFECTLY. Thank you!!!!!!!

Try using an expression - either one of the following should work.

Expression is
Nz([Field1],"") <> NZ([Field2],"")

OR

Expression is
[Field1] & "" <> [Field2] & ""


John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

Okay, so I figured out how to have a field be highlighted if it doesn't equal
another field.... but what do I do if the field is blank? For instance...

Field 1 Field 2
Verbal Warning

If I want to highlight both these fields because they do not equal, how do I
do that? Currently, my conditional formatting does not highlight either field
in this situation.

Thanks!!!