Change detail font when one fieldvalue = "TOT"

  • Thread starter Thread starter Rich
  • Start date Start date
R

Rich

I have a report that shows all of the data in a users query. I need
to change the font color for all of the text boxes in the detail row
when the [div] textbox value is TOT. How can I do that?
 
I have not used this technique and have not tested it, but my first thought
would be to use the report's detail section Format event.

If Me.div = "TOT"
Me.div.Fontcolor =
Else
Me.div.Fontcolor =
End If
 
I have a report that shows all of the data in a users query. I need
to change the font color for all of the text boxes in the detail row
when the [div] textbox value is TOT. How can I do that?
Click to expand...

Use conditional Formatting.

Select all the controls in the section (that you wish to change the
font color on).
Click on Format + Conditional Formatting
Set
Condition1 to
Expression Is
Then write
[Div] = "TOT"
in the next dialog box.
Select the color you wish and save the changes.
 
Back
Top