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.
As an example, for the sales report showing monthly turnover per product where the product monthly total falls below a target value; a format is set in order that the value turns the number to red and bold which clearly stands apart from the rest which did meet the target value (as a regular format).
The conditional test has to be may well statement that if TRUE will apply the format set or if discovered to be to FALSE is ignored. You can nest multiple conditions (around 3 for versions pre 2010) which logically flows inside order set to trigger a conditional format (when it can). Therefore, you can have three different formats for similar field with some other data value ranges.
The way to set Conditional Formatting
If you don’t distinction between a questionaire and report when using this tool but here I am going to target the report object in Microsoft Access.
One inch design look at a written report, go through the field (control) which will retain the conditional format.
2 Right phone about the control and judge ‘Conditional Formatting’ from your pop-up menu or locate the identical command from the toolbar or ribbon bar (with regards to the version being used).
3 Evaluate if the rule will be based on a value, a symbol or in case a form, Field has focus.
4 Set the logical operator or write the logical expression that may be a calculation (an equation).
5 Choose your format options which appear as icons and so are self-explanatory with all the preview to assist.
6 Click OK.
Continue this if multiple condition is needed to a similar control or across other controls.
In Access 2010, you own an additional choice to choose Rival other records and you’ll also set data bars which can be gradient filled bars using aggregate calculations and will specify data types and values which are also expressions. Make use of the Microsoft Access help for more information by typing the subsequent keyword phrase “conditional formatting – compare to other records”.
Another Helpful tip! Alternatively or as an addition to using Conditional Formatting, users could also choose different colours (available colors: Black, Blue, Green, Cyan, Red, Magenta, Yellow, White.) by using a custom number format instead. By way of example, the code for any blue positive number or even a red negative number would look something similar to [Blue]0.00;[Red]-0.00.
Related posts:
