Power Tip: Supercharge conditional formatting by using a bit of code

Over the past few versions of Access, the product team has steadily added more conditional formatting functionality for forms and reports. For example, in Access 2010, you can add up to 50 conditional formatting rules for each object without having to write any Visual Basic for Applications (VBA) code. However, if you're working in an earlier version, or if you just prefer to use VBA to perform formatting tasks on your forms and reports, Juan Soto of AccessExperts.net has blogged about some VBA-based conditional formatting techniques that he has implemented recently.

...(read more)

Source: http://blogs.office.com/b/microsoft-access/archive/2011/04/06/power-tip-supercharge-conditional-formatting-by-using-a-bit-of-code.aspx

Hewlettpackard High Tech Computer Hon Hai Precision Ind Hynix Semiconductor