Change Color Of Text Box In Report

[zyus]

I have a text box that calculate the difference between [text1]-[text2].

How to set a different color if the result is negative.

Thanks

 

[John W. Vinson]

I have a text box that calculate the difference between [text1]-[text2].

How to set a different color if the result is negative.

Thanks

Open the report in design view; select this textbox; select Format...
Conditional Formatting from the menu. It's pretty selfexplanatory.

 

[Duane Hookom]

You can also simply set the Format Property. Check Help to find something
like
Format: $#,##0.00[Green];($#,##0.00)[Red];"Zero";"Null"
This expression sets the format to currency with positive values in Green
and negative values in Red.