MS Access: Conditional formatting in Access 2007
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:
- When a field contains a particular value
- When a particular expression is found
- 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.
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.
Now when the Company Name field has focus, the background color will change to blue.