[AccessD] Conditional Formatting bug?

Arthur,

I am away from my computer today, so can't play with it as I would like.

As an experiment, can you change the Conditions to use the 'Expression 
is...' option, and then enter like this:
[CalculatedBalance]>0
See if that works correctly.

If not, try then with an expression back to raw data, e.g...
YourFunction([YourField])>0

Regards
Steve


Arthur Fuller wrote:
> The formatted column calls a function and returns a currency value that is
> positive or negative or zero. The name of the column is CalculatedBalance.
> There are two formatting rules:
> 
> Condition1: Field Value is greater than zero, paint the foreground green.
> Condition2: Field Value is less than zero, paint the foreground red.
> 
> The behavior is that all non-zero values are painted green. Zero values are
> left alone (black on white).