YES/NO Color

[dr.bob]

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

 

[KenHigg]

Have you tried conditional formatting?

 

[dr.bob]

Conditional formatting

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

 

[KenHigg]

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

 

[dr.bob]

YES/NO field

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

 

[KenHigg]

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?

 

[dr.bob]

You are right

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

dr.bob

 

[dr.bob]

YES/No Box in reports

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

 

[KenHigg]

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

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

 

[dr.bob]

elaborate please

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

Thanks for your help.

dr. Bob

 

[KenHigg]

.
.
.
.
Try this: