J
JHB
Hi:
I have a couple of expressions on a form, and I want to set them up
with conditional formatting. They are to be RED when the result of the
expression is below zero and blue when the expression result is zero
or positive. For the life of me I cannot make it happen!
In development mode, I have highlighted the fields and set the field
results to:
equal or greater than zero = blue
less than zero=red
Even when the result is negative (bracketed because its a $ value) it
is treated as if it was positive.
Can someone give me a pointer as to what to do.
I have a couple of expressions on a form, and I want to set them up
with conditional formatting. They are to be RED when the result of the
expression is below zero and blue when the expression result is zero
or positive. For the life of me I cannot make it happen!
In development mode, I have highlighted the fields and set the field
results to:
equal or greater than zero = blue
less than zero=red
Even when the result is negative (bracketed because its a $ value) it
is treated as if it was positive.
Can someone give me a pointer as to what to do.