Change detail font when one fieldvalue = "TOT"

[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?

 

[Klatuu]

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

 

[fredg]

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?

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.

 

[Maurice]

and if you do want to use Dave's code I believe it is forecolor instead of
fontcolor.

hth