Conditional Format

[rbb101]

I have the following equation in the control source of a text box in a
report.

=IIf(([Suffix]<>[CFR IAD Key Metrics].[Report]![Suffix]),"No Match","Match")

If the response is "No Match" I would like the font to be bold and red.
Conditional formatting works, but I have 10 similar equations in this report,
and conditional formatting only works for 3 or 4 items.

Is there a way to get the same results as conditional formatting on more
than 4 text boxes.

 

[Ken Snell \(MVP\)]

Each textbox can have its own conditional formatting settings. And each
conditional format can have up to three conditions. So, if I'm understanding
your wishes correctly, you should be able to do what you want.

 

[rbb101]

Okay, I think I found my error.

When a set up the report, I copied and pasted mulitle text boxes, then
changed the equation in the control source. After I added the conditional
formatting on the 4th text box, it changed the remainder to read #Name?.
This may be causing the problem.

Each textbox can have its own conditional formatting settings. And each
conditional format can have up to three conditions. So, if I'm understanding
your wishes correctly, you should be able to do what you want.

--

Ken Snell
<MS ACCESS MVP>

I have the following equation in the control source of a text box in a
report.

=IIf(([Suffix]<>[CFR IAD Key Metrics].[Report]![Suffix]),"No
Match","Match")

If the response is "No Match" I would like the font to be bold and red.
Conditional formatting works, but I have 10 similar equations in this
report,
and conditional formatting only works for 3 or 4 items.

Is there a way to get the same results as conditional formatting on more
than 4 text boxes.

 

[rbb101]

I created a whole new set of text boxes. The conditional formatting works on
the first four of 10 text boxes, but when I do it on the fifth box, the
remaining text boxes show #Name? in boxes 5-10. If I add the conditional
formattiong to box 10, then boxes 4-9 show #Name?. I seems like you can only
add conditional formatting to 4 text boxes. Is there a way to get around
this using code or some other method?

Each textbox can have its own conditional formatting settings. And each
conditional format can have up to three conditions. So, if I'm understanding
your wishes correctly, you should be able to do what you want.

--

Ken Snell
<MS ACCESS MVP>

I have the following equation in the control source of a text box in a
report.

=IIf(([Suffix]<>[CFR IAD Key Metrics].[Report]![Suffix]),"No
Match","Match")

If the response is "No Match" I would like the font to be bold and red.
Conditional formatting works, but I have 10 similar equations in this
report,
and conditional formatting only works for 3 or 4 items.

Is there a way to get the same results as conditional formatting on more
than 4 text boxes.