conditional formatting

[PaulA]

I am trying to use conditional formatting for an Access report (for the first time). I put three conditions in place using the expression option in the conditional formatting window. Two conditions are based on values in other fields. The third condition, the field to be formatted, is also based on if the field has a null value.

When I open the report, the field for all records is formatted with the conditional format whether the conditions are met or not.

My expressions are:
[Hyperlipidemia]=-1
[CountOfAssessID]>=2
IsNull([LDL2])=True

Any ideas as to what the problem could be?

Thanks.

 

[boblarson]

1. Did you change them to be Expression Is ?

2. The 3rd expression is a little off as it should NOT have Expression Is but Value IS and you just put

NULL

 

[PaulA]

Thanks for your quick response.

I had tried the "Field Value Is" as "Equals To" with Null but it didn't work either. I just tried again and the same thing is happening.

 

[boblarson]

Thanks for your quick response.

I had tried the "Field Value Is" as "Equals To" with Null but it didn't work either. I just tried again and the same thing is happening.

You don't use = Null

It is either

IsNull([FieldName])

or in this case

Value Is -----> NULL

The other ones need to have Expression IS if they are referring to other fields.

 

[PaulA]

Pardon my being dense, but it seems that I have to choose some expression such as "Equal to" or "between" or "greater than or equal to", etc. Am I missing something?

I tried the expression that you included for "Expression Is" as well.

The field is still reformatted for all records.

 

[boblarson]

Sorry, I was going off of memory. I just went to check and you have to use

Expression Is

for nulls

And the thing to use is

IsNull([YourFieldNameInBrackets])