Change color of value if value is negative

[scra]

I know there is a way to code a field if a value of that field is a negative. I want to code a negative value in color red font and positive value as green.

 

[scra]

I had forgotten how to code it. Anyone???

 

[Axworthy]

Look under the menu item Format / Conditional Formatting.

 

[dhookom]

You can use the Format property rather than Conditional Formatting. Check Help on Format Property Numeric Fields.

Duane
Hook'D on Access
MS Access MVP