Microsoft Access Database: Discover How Easily to Apply Conditional Formatting in Microsoft Access

In the days before Microsoft Access 2000, trying to create a dynamic shape changes to a form or report based on the value or expression, or need a macro or VBA code, which meant learning how to program an Access database application.

In the days before Microsoft Access 2000, trying to create a dynamic shape changes to a form or report based on the value or expression, or need a macro or VBA code, which meant learning how to program an Access database application.

...

When the version 2000 is released and up to and including version 2007, Conditional Formatting becomes a life saver as it provides a quick way to select up to three conditions that logically tested and changed the look of their size, with no programming skills at all.

...

What is Conditional Formatting?

Well, if you know Microsoft Excel, you probably know what it is, but just in case you were that day, here's an overview.

conditional formatting feature format that applies to forms and reports in the field (control) to listen (look) for a value change that is applied then the format of your choice based on the logic test it performs. Option format could be a font color , bold, italic, background color and other basic equipment that runs from the actual value returned is the value of the data.

For example, the monthly sales report shows sales for each product which is the product of the monthly total fell below the target value, the format is set to a value into a number of red and bold that clearly stands out from the rest who did not meet target value (as a regular form of ).

conditional test must be a logical statement that, if TRUE will be applied to a form, or if it is determined that the FALSE is ignored. You can nest multiple conditions (up to 3 versions before 2010), which logically flows in the order to launch a conditional formatting (if you can). So, you have three different formats for the same area with different value ranges.

How to set the Conditional Formatting

There is little difference between the forms and reports when using this tool, but here I will focus on building reports in Microsoft Access.

1. report in Design view, click on the field (control), which will contain conditional formatting.
2. , right-click the control and select the 'Conditional Formatting "from the pop-up menu, or find the same command on the toolbar or Ribbon bar (depending on version used) .
3. to decide if the rule is based on value term , or if the format Field focus .
4. Set the logical operator or write a logical expression that can calculate (formula ).
5. Set the logical operator or write a logical expression that can calculate (formula ).
...
6. Click on OK.

Repeat this process if more than one condition must be the same control or through other controls.

Repeat this process if more than one condition must be the same control or through other controls.

...