Please help w/conditional formatting text in report

[TotallyConfused]

I am trying to apply a different color font to a control box. I can do that
to the first control box using the "conditional formating". My problem is
that in the report there are two control boxes. 1) Names and 2) totals. I
would like the word "blank" in the Names column to be in Red font and the
total in colum 2 be the same. I tried to concatenate the Name control box
with total control box but I get an error. Can you please help? Thank you.

 

[Rob Parker]

You can set the conditional format for a control based on the value of
another control. You will need to select "Expression Is" in the combo-box
for the condition for the second control, and enter (assuming that "Names"
is the actual name of the first control)

[Names]="blank"

in the expression area; then select the red as the text colour.

HTH,

Rob

I am trying to apply a different color font to a control box. I can do that
to the first control box using the "conditional formating". My problem is
that in the report there are two control boxes. 1) Names and 2) totals. I
would like the word "blank" in the Names column to be in Red font and the
total in colum 2 be the same. I tried to concatenate the Name control box
with total control box but I get an error. Can you please help? Thank

you.