Change Color Of Text Box In Report

  • Thread starter Thread starter zyus
  • Start date Start date
Z

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
 
I have a text box that calculate the difference between [text1]-[text2].

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

Thanks
Click to expand...

Open the report in design view; select this textbox; select Format...
Conditional Formatting from the menu. It's pretty selfexplanatory.
 
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.
 
Back
Top