[AccessD] Conditional Formatting bug?

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).

Arthur

On 1/2/08, Steve Schapel <miscellany at mvps.org> wrote:
>
> Hi Arthur,
>
> I have used Conditional Formatting fairly often, both in Access 2000 and
> Access 2003, with more than one condition, based on the value of a
> calculated control, and I have never experienced the type of problem you
> have described.
>
> Can you give us the details of how you have the CF set up?
>
> Regards
> Steve
>
> Arthur Fuller wrote:
> > Hi all,
> >
> > I have an A2K app with one continuous form "browser" screen that
> displays a
> > calculated column called Balance that has conditional formatting. It is
> > behaving strangely so I'm wondering whether there is a bug in Access on
> > conditional formatting. There are two formats applied: if the balance is
> > negative, display it in red. If the balance is positive, display it in
> > green. The default is black. What happens here is that even with only
> one
> > rule, the red rule, all non-zero balances get colored red. It doesn't
> matter
> > whether I add the second rule or not. Just adding one conditional format
> > exhibits this behavior.
> >
> > Can anyone verify that it works correctly on some A2K database? I mean,
> this
> > is so simple, it has to be a bug in Access.
> >
> > TIA,
> > Arthur
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>