Conditional Formatting on a Report

[Guest]

I have a report that I have created. On Items that are No I want to be able
to make that bold and put a shading behind it to make it stick out. I used
the conditional formatting options and set the Expression Is No but I am
not getting it to work. Is there something else I should be doing?

Thank you

 

[Guest]

Hi

Try this
Expression Is ="No"

I assume this is text and not a check box

 

[Guest]

That worked perfectly. Thank you

Hi

Try this
Expression Is ="No"

I assume this is text and not a check box

 

[Guest]

The expression should evaluate to True or False depending on the value of the
Boolean (Yes/No) field in question so you need to include the field name and
equality operator (equals sign) as well as the 'no' value. As regards the
value, 'yes' and 'no' are really just folksy terms for the Boolean values
True and False, so the expression to conditionally format a control if the
value of the Boolean field is false would be like this:

[YourBooleanFieldName] = False

Alternatively you could use the following expression:

Not [YourBooleanFieldName]

Either of the above expressions will evaluate to true if the Boolean field
is False.

Do this for each control whose formatting you want to conditionally change
when the value of the Boolean field is False.

Ken Sheridan
Stafford, England