Coloured field boxes (1 Viewer)

[L4serK!LL]

Is it possible to have the field boxes of a continuous form for one specific value of a checkbox field coloured white or yellow or ... ?

If yes, how can i do this? I looked around but found nothing except for the Conditional Formatting which I don't see capable of accomplishing this
I tried to do it with VBA but it coloured ALL the field boxes instead of just the specific row...

 

[Tomki]

This is one of the ways that you can do it:
On the field 1 AfterUpdate do this:

If Me.field1= "blabla" Then
Me.field2.BackColor = 241146240 (for desired color search on that field - Format - Backckolor)
End If

The same way you can change the Fonts Color if you want.

 

[Rich]

If your using A2k and later then conditional formatting is your best bet, in versions earlier than that you have to cheat