Conditional Formatting on another Field

[GKuenning]

Is it possible to do conditional formatting on another field than the one you have selected?

For example: If I want my "First Name" field to be red, if my "Yes/No" Field is "Yes"

Thanks.

 

[Sohaila Taravati]

Yes it's very Possible! You can do it in the code behind the form.

If ([Yes/No Field]= -1) then
Me.FirstName.forecolor = 255
Else
Me.FirstName.forecolor = 0
End IF