[AccessD] Conditional Formatting Puzzler - Access 2007

Gustav,

I have never used this approach, but I plan to experiment with it.

Thanks,
Brad

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav Brock
Sent: Tuesday, February 12, 2013 4:27 PM
To: accessd at databaseadvisors.com
Subject: Re: [AccessD] Conditional Formatting Puzzler - Access 2007

Hi Brad

Why not just use the Format property and specify a colour:

0.00;[Red]-0.00

/gustav

Subject: [AccessD] Conditional Formatting Puzzler - Access 2007

All,

I have used Conditional Formatting a few times in the past and never ran
into any problems.
Recently, I stumbled upon something that seems strange.

I have an Access 2007 report with an amount field.  If the amount is
negative, I simply want to change the font color to red.
I set up a single "Conditional Formatting" condition that says "Field
Value Is" "Less than" 0.
The Preview shows the field in red.
However, when I view the report, the field is shown in black and not in
red.

I must be missing something.  This seems so simple.  It appears that
Access is not detecting that the fields is negative.

Thanks,
Brad

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.