[AccessD] Conditional formatting -- known bug?

Dan Waters dwaters at usinternet.com
Wed Jun 27 14:32:55 CDT 2007


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
 











































































































































































More information about the AccessD mailing list