Microsoft Access Database: Know how Easily to Apply Conditional Formatting in Microsoft Access
Dads and moms before Microsoft Access 2000, wanting to create dynamic format changes with a form or possibly a report based on a changing value or an expression required sometimes a macro or some VBA code which meant finding out how to program your Access database application.
When version 2000 was published or higher to and including version 2007, Conditional Formatting became a life saver as it provided a quick method to select as much as three conditions which logically tested and changed the design of your formats without the programming abilities at all.
In Access 2010, it is often improved and extends after dark three conditions in addition to another quick pre-defined options releasing the richness of Microsoft Access forms and reports that it gives the job.
What’s Conditional Formatting?
Well, if you know Microsoft Excel, you almost certainly understand what this can be but simply just in case you were out that day, here’s a preview.
Conditional Formatting can be a format feature which is placed on your forms and reports to a field (control) that listens (looks) for your value to change which in turn applies a format of your choosing based on the logical test it performs. The format options may be the font colour, bold, italic, background colours as well as other basic enhancements that is triggered through the TRUE value returned around the data value found.
