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.