Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Print negative values in red on Report

Status
Not open for further replies.

mystuff

Programmer
Apr 30, 2004
86
0
0
US
Hi,

Can anyone tell me how I would print a negative value in red and positive values will remain in black?

Thanks
 
You could try using conditional formatting on the control (2000+ versions), or in the format property of the control:

[tt]0.00;[Red]0.00[/tt]

press F1 while in the format proerty to see more about how to build those formats

Roy-Vidar
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top