Spotting Trends Quickly with Conditional Formatting in Microsoft Access

Conditional formatting was introduced from Microsoft Access 2000 and has been improved for 2010.

Users you will be more familiar with using this useful tool in Excel and the same logic and workflow applies in your database too.

The following video tutorial is a quick overview that will give you the confidence to explore this simple but effective utility in Microsoft Access 2010

Spotting trends quickly with conditional formatting in Microsoft Access

Additional points to consider with your Microsoft Access database conditional formatting tool

This can be applied to both forms and reports for each control or a selection of controls and can be logically chosen to the fields value or an expression which is a logical formula yielding true or false.

Earlier versions of Microsoft Access had an inferior tool with up to 3 conditions allowed per control but it still also had the added benefit of setting the ‘has focus’ option which changed its colour when the insertion point was placed in the field’s control.

There are other ways to utilise changing colours especially for numbers in your Microsoft  Access database application but you will need to investigate this further.

This entry was posted in Forms, MS Access, Reports, Utilities and tagged , , , . Bookmark the permalink.

3 Responses to Spotting Trends Quickly with Conditional Formatting in Microsoft Access

  1. Ben says:

    Hi, you need to be in a form (not a report) and there is a drop-down control in Condition Formatting when choosing the type of expression for a new rule. It has the standard two; ‘Field Value is’ and ‘Expression is’ with the third option being ‘Has focus’. Let me know what you are trying to do and I will confirm the logic test for you. Thanks, Ben Beitler

  2. Giorgio says:

    “it still also had the added benefit of setting the ‘has focus’ option”
    Hi Ben, where can I find this option?

  3. Ben Beitler says:

    In Access 2010, you can also use the alternate row (record) formatting option which is another useful format especially for reports. Take a look at the design area of a report for this format option.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

Confirm you are human.