Access Conditional formatting

[gheyman]

I have a bunch of fields on a form where I entered conditional formula

"Check values in the current record or use and expression
Format on cells where the:
Field Value is greater than 0


Then the formatting is set to make the fore color red

if the value, which is calculated, results in 0 it stays black, if its greater than 0 it turns red BUT if its a negative number (like -1) it turns red. negative 1 is less than 0 so it should stay black. What am I doing incorrectly?

I tried "0" which not difference on results

 

[apr pillai]

What benefit is there of adding extra code of the sgn function when testing the value will do the same?

Yes, you are right. [FieldValue] <= 0 will do for Black Color.