Conditional Formatting - Not seeing negative numbers as less than zero!

[NewShoes]

Hi All,

Could really use some help on this one! I have conditional formatting on a text box in my form that makes the text red if the value is equal to or less than zero. However, when the number drops below zero, for example -2, the text does not format to red!

Anyone know a way around this?

Thanks,
-NS

 

[bob fitz]

Could the problem actually be that you are using the wrong syntax to set the conditional format, rather than a problem with values <0 ?

You could check this by changing the formating to show as red if value is >0. If this does not work as well then I think the problem will be with the syntax used. If this is the case then please post your syntax.

 

[Galaxiom]

If the the bound field is text rather than number then the comparison is alphabetic and:
-1 > 0