tech on the net
Home About Us Feedback Site Map


Access Excel Word


SQL Oracle / PLSQL SQL Server MySQL MariaDB PostgreSQL

Web Development

HTML CSS Color Picker


C Language


ASCII Table Linux UNIX Java Clipart Joke of the Moment
Share this page:

MS Access: Conditional formatting in Access 2007

See solution in other versions of Access:

Question: In Microsoft Access 2007, how can I apply a conditional format on a text box? I want to change the background color to blue when the text box has focus. How do I do this?

Answer: Conditional formatting allows you to change the behavior of a form object when one of the following conditions is met:

  1. When a field contains a particular value
  2. When a particular expression is found
  3. When a field has the focus

In this example, we'll cover conditional formatting when a field has the focus.

To do this, open the form in design view. Right click on the text box that you wish to conditionally format. Select "Conditional Formatting" from the popup menu.

Microsoft Access

A Conditional Formatting window should appear. Under the condition 1 drop-down box, select "Field Has Focus" and then choose the formatting conditions that you want to apply when the field has focus.

In this example, we selected the "paint can" icon and selected blue as the background color.

Microsoft Access

Now when the Company Name field has focus, the background color will change to blue.

Microsoft Access