[AccessD] Conditional Formatting Puzzler - Access 2007

Brad Marks BradM at blackforestltd.com
Tue Feb 12 16:11:09 CST 2013


Rocky,

I will try a calculated value.

Thanks,
Brad 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
Sent: Tuesday, February 12, 2013 3:11 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Conditional Formatting Puzzler - Access 2007

 
"plugged with data via VBA code"  that's probably why - I'm guessing
that
the conditional formatting function is not being triggered or it is
triggered before you put the value in the text box via VBA.

Can you make that field a calculated value in the query?

R 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks
Sent: Tuesday, February 12, 2013 12:50 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Conditional Formatting Puzzler - Access 2007

Rocky,

Thanks for the idea.

I am simply viewing the report on the screen - no printer involved yet.

Other conditional formatting works when the data comes from a query.

The report field that I am having trouble with is being plugged with
data
via VBA code.

Brad 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin
Sent: Tuesday, February 12, 2013 2:42 PM
To: 'Access Developers discussion and problem solving'
Subject: Re: [AccessD] Conditional Formatting Puzzler - Access 2007

WAG - is the printer set to print in color? (I've been gothcha'd by that
one
before) 

R
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Brad Marks
Sent: Tuesday, February 12, 2013 12:24 PM
To: Access Developers discussion and problem solving
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

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


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

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




More information about the AccessD mailing list