Problem With Continuous Forms

[Dan]

Hello. I'm using Access 2003. I'm having trouble with
some conditional formatting that I would like to do when
using a continuous form. Here's my code:

If (txtApplicationStatus.Value = 1) Then
txtApplicationStatus.ForeColor = 255
End If

I only want this to apply to the particular record that
meets this condition. The way it is now, if this
condition is met by any record, then all of them display
red. Any help would really be appreciated. Thanks.

 

[Allen Browne]

Replace the code with conditional formatting.

In form design view, select the text box.
Choose Conditional Formatting on the Format menu.

 

[Dan]

Then I can only have three conditions, and It seems as if
they all have to have the same text color. I want a way
to do it in VB

 

[Allen Browne]

As you found, coding in VBA applies the formatting to all rows.

It is possible to use the Format property of a text box that contains
numeric values to get 4 colours, if you arrange so the text box has
positive, negative, and zero values, but that is less useful than the
conditional formatting.