Changing color on continuous form

[Lana]

Hi!

I have a subform which is a continuous form with 1 text-box and 1 check-box.

I was trying to change font color of textbox depending on value of check-box.
I tried to set in Conditional Formatting the following rule: Me.Check9=True,
and make it red-bold. - but it guess it doesnt work that way? (as i saw no
changes.)

I cannot use the Value because my Check9 box has different ControlSource
depending on the value of other combo on main form.

I tryed also this code on the OnChange Event of my Combo on main form:

If Me!SF_Ex1.Form![Check9] = True Then
Me!SF_Ex1.Form!Text2.ForeColor = "332200"
Else
Me!SF_Ex1.Form!Text2.ForeColor = "000000"
End If

This does change color, but it changes for all records on my subform. They
are all red or all black depending on what was the value of the Check9 for
the first record in my list.

Is there any way to solve this?

Thanks for any help
Lana

 

[Douglas J Steele]

Unfortunately, while you may think that there are multiple check boxes and
text boxes on your continuous form, to Access, there's only one of each
control. That means that when you try & change 1, you change them all.

Try using Conditional Formatting.