Is there a way to make a NO box to be red and a Yes box to have a check mark?(by default it is a check mark) I'm getting this report from a querie and am using a date parameter as well. There are about 14 YES/No fields. Sometime some will be Yes and sometime they will be NO. I need a way to spot the NO in a report.

Thanks,

dr.bob

Have you tried conditional formatting?

Don't think I have done this in Access. In Excel it is no problem.
Bob

In the report, right click the text box and do 'conditional formatting'...

The field is a YES/NO field. The report comes from my query which is generated from my table. The yes/no fields are set that way in the table. In the report,the user will check the box for Yes and leave it blank if it is NO. Not concerned about the color in the Query, or the form but would like for it to show up in the Report.

Thanks for sticking with me on this.

Dr. Bob

You say 'In the report,the user will check the box ...'. In my reports, they simply print, the user does not check anything. I leave that to the form. Is this the same as you're doing?

Yes. Sorry for the confusion. They do the check marks in the Form.

dr.bob

Conditional Formatting is not an option with the YES/NO box in design view (In Reports) .Conditional Formatting is grayed out. Not Selectable.

Thanks,

dr.Bob

I would simply do a new fld that converts the yes / no to a text equivalent.
Something like:

MyNewFld: iif(myFld = True, "Yes", "No")

Your idea is probably a good one. But I do not have a clue how to perform it.

Thanks for your help.

dr. Bob

.
.
.
.
Try this: