Conditional Formatting Issue

  • Thread starter Thread starter JHB
  • Start date Start date
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.
 
JHB,

What version of Access are you using, it may make a difference?

When you say "$ value" do you means the field type is Currency?

In the Conditional Formatting form on the Format menu I set up a
Currency type field like this :-

-Condition 1----
Field Value is less than 0 (back color as Red)

-Condition 2 ---
Field Value is greater than or equal to 0 (back color as blue)

and it works as you wanted. Is this what you did?

Peter Hibbs.
 
Back
Top