Conditional Formatting

[Amy]

I am trying to simply highlight any field value that has "No" in my report.
For some reason it isnt working. I have used conditional formating before so
I am not sure what is wrong.

Any ideas?

 

[Ken Sheridan]

Amy:

If the field is a Boolean (Yes/No) data type the condition would be:

Field value is ……equal to……False

If its text data type:

Field value is ……equal to……"No"

Then set the fore-colour and/or back-colour as desired in the conditional
formatting dialogue.

Ken Sheridan
Stafford, England

 

[Amy]

Thank you Ken,

I didnt know about the "False" option so I did try that. However, neither
one of those suggestions worked. I have tried doing this in a report in
layout and design view.

I just dont understand whats wrong and why this isnt working. Any other
thoughts?
--
Thanks,
Amy

Amy:

If the field is a Boolean (Yes/No) data type the condition would be:

Field value is ……equal to……False

If its text data type:

Field value is ……equal to……"No"

Then set the fore-colour and/or back-colour as desired in the conditional
formatting dialogue.

Ken Sheridan
Stafford, England

 

[cna48]

Sorry if this sounds insulting, but do you have any records that actually
meet that criteria?

Also try setting the original format to how you want it highlighted and then
set the conditional format to

Expression <> "No" to get it back. This is just a quick double check of
your data.

Hope this helps.-Candy

Thank you Ken,

I didnt know about the "False" option so I did try that. However, neither
one of those suggestions worked. I have tried doing this in a report in
layout and design view.

I just dont understand whats wrong and why this isnt working. Any other
thoughts?

 

[Ken Sheridan]

Amy:

True and False are the constants normally used for Boolean values, but in
Access you can also use Yes and No. Let take it from square one:

1. Open the report in design view,

2. Select the control in question.

3. Right click and select Conditional Formatting.

4. In the dialogue select 'Field value is' from the left combo box, 'equal
to' from the centre one, and enter False (no quotes) in the right text box if
the field is a Yes/No data type, "No" (in quotes) if it’s a text data type.

5. Select whatever colours you want for the back-colour and/or fore-colour
of the control when its value is No.

That should do the trick. If not I'm as puzzled as you.

Ken Sheridan
Stafford, England

Thank you Ken,

I didnt know about the "False" option so I did try that. However, neither
one of those suggestions worked. I have tried doing this in a report in
layout and design view.

I just dont understand whats wrong and why this isnt working. Any other
thoughts?