|Figure 1 - Highlight mature invoices with Conditional formatting|
|Figure 2 -Conditional formatting expressions for the coloured box|
Multiply conditional formatting 10 times and what do you have ?As you can see in the figure 2, conditional formatting can get out of hand really quickly and you soon will wish that you could document and program conditional formatted fields in VBA. We found out this week that we couldn't find an elusive piece of code to document the actual expression in the conditional format equation. Finally after much digging, I found the code in the sample database that Rick Dobson submitted for his 2005 Smart Access article on Conditional Formatting. I have now published that elusive code in this new article on how to list conditional format expressions
and to get into this, you will need to download the Access 2007 sample database here
Tip: To make a colourful highlight box as in figure 1, put the forms index field in second text field and lock it. The conditional format will need to show Red text on a Red background for the Red condition. You can work out the rest.