Susan Harkins
ssharkins at setel.com
Wed Jun 27 15:12:32 CDT 2007
Well how odd -- but thank you! ;) Susan H. Hi Susan, I had a similar bug about 3 years ago and reported it to MS. They agreed it was a bug. Perhaps this is fixed in 2007. The workaround was to multiply any numeric values by 1 in the expression I typed into the conditional formatting screen. BOL! Dan -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Harkins Sent: Wednesday, June 27, 2007 1:16 PM To: 'Access Developers discussion and problem solving' Subject: [AccessD] Conditional formatting -- known bug? I've never used 2003's Conditional formatting in a report. I just tried to apply conditional coloring to a grouped report. The conditions work just the opposite of what I expect. For instance, if I want the value to be in red if it's less than 20, I tried Less than 20 and less than or equal to 20 -- tried them both. Access is displaying values greater than 20 in red, not less than. Susan H. -- 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 Internal Virus Database is out-of-date. Checked by AVG Free Edition. Version: 7.5.472 / Virus Database: 269.9.1/857 - Release Date: 6/20/2007 2:18 PM