Power tip: supercharge conditional formatting with a little code

Over the past the product team has few versions of access constantly more conditional formatting functionality for forms and reports added. In access 2010, you can add conditional formatting for each object, for example, up to 50 rules without having to write any Visual Basic for applications (VBA) code. However, if you work in an earlier version, or if you prefer only VBA for formatting tasks on your forms and reports use, Juan Soto of AccessExperts.net has blogged some VBA-based conditional formatting techniques , which he has recently introduced. It provides a code example, you can copy and try for yourself, so take a look!

Thanks Juan!

--Chris downs

You have a power tip you would like to share? Send us at accpower@microsoft.com.

View the original article here