conditional formatting

[ingrid]

I have a subform in which I want to use conditional formatting. The recordsource is a query, so the problem is how to determine what value a specific field has. After that I think it´s easy:

If field.value = "bla" then
field.backcolor = 0
Else
field.color = 255
End If

I hope anyone can help me.

 

[Travis]

From the Help File Access 2000



Change the color of the control that has focus on a form

1. Open the form in Design view or Form view.
2. Make sure that the control is selected, and then, on the Format menu, click Conditional Formatting.
3. In the Condition x area of the Conditional Formatting dialog box, click Field Has Focus in the first box.
4. Select the font style, color, or other formatting that you want the field to have when it has focus.
   [/list=1]
   
   
   Note When you open the Conditional Formatting dialog box, it displays the current default formatting for the selected control, including colors, font styles, and any expressions that you may have defined for the field.

 

[ingrid]

I'm using access 97. Could that be the problem?

 

[namliam]

A97 doesnt support conditional formatting