Office 2010 Key Power Tip Supercharge conditional

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 Acces######perts.net has blogged about some VBA-based conditional formatting techniques that he has implemented recently. He provides a code sample that you can copy and try out for yourself, so take a look!

Thanks Juan,Office 2010 Key!

--Chris Downs

Got a Power Tip you'd like to share? Send it to us at accpower@microsoft.com.


<div