Color Number that are Positive

[JPinter]

Hello,

Does anyone know how to make a number on a report be a different color if it is a positive amount, but black if it's a negative amount.

Thanks,
Jeff

 

[smedvid]

One approach is to use the Detail - Print Event.... Refer to thread703-383944 example on how to add a backshade to line... htwh Steve Medvid
"IT Consultant & Web Master"
e-Mail: Stephen_Medvid@GMACM.com

http://www.saveourfarm.com

Chester County, PA Residents
Please Show Your Support...

 

[PaulBricker]

In the Format Event for the Section with your info, put this
If Me.NumberField >= 0 Then
Me.NumberField.ForeColor = vbGreen 'or what ever
Else
Me.NumberField.ForeColor = vbBlack
End If

Paul

 

[MichaelRed]

but the convention is the reverse. Positive Values are generally black or green and negative values red. Applictions have different expectations or requirements, but this is almost certainly going to generate confusion.

MichaelRed
m.red@att.net

There is never time to do it right but there is always time to do it over