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. He provides a code sample that you can copy and try out for yourself, so take a look!
Got a Power Tip you’d like to share? Send it to us at firstname.lastname@example.org.