Postive negitive numbers in conditional formatting of a report

[Frank]

I have a money field, I like money owed in red, zero blanace white and
credited amounts above bill in green. Seems no matter what I due it treats
Pos & Neg numbers and positive numbers. using access 2000.

 

[Rick Brandt]

I have a money field, I like money owed in red, zero blanace white and
credited amounts above bill in green. Seems no matter what I due it
treats Pos & Neg numbers and positive numbers. using access 2000.

Check the help file for the format property for numbers. When used against
numbers the format property has four sections separated by semi-colons. They
set formatting for Positive, Negative, Zero, and Null. Color is one of the
things that can be set in this manner.