changing text colors in a report 1

[fredk]

Is there a way to have negative numbers red and positive numbers black in a report? I have done this on forms but not sure how to achieve it in a report???

Thanks in advance for the help!!!!



Fred

 

[CosmoKramer]

In the On Format event of your report's detail section put code like this:

If Me.txtYourField < 0 then
   Me.txtYourField.ForeColor = vbRed
Else
   Me.txtYourField.ForeColor = vbBlack
End If
[code]

 

[fredk]

Perfect, thank you very much - I was not sure what event to use- One other thing - To apply that to all fields in the detail section.... I am thinking I could use a variable but I am not sure how to run through all the text boxes ?? Thanks again for your help!!!!