conditionel format aan continous form

E

el_bennito

I have a continous form , on witch I need to apply 12 conditions.
Access only has standard 3 conditions build in to. so I can't use that
function .I now use the following code

Private Sub cboKlasVakID_AfterUpdate()
Select Case cboKlasVakID.Value
Case Is = 29
cboKlasVakID.BackColor = vbRed
Case Is = 30
cboKlasVakID.BackColor = vbRed
......

End Sub

problem is that whole form gets the same color.
any one got a solution?

benny
 
K

Ken Sheridan

The nearest you can get to this would be to create a separate Colours table
with column ColourID and another column containing twelve bitmaps of each of
the colours. The values in the ColourID column should match the 12 possible
values of the KlasVakID column in the form's underlying table. Base the form
on a query which joins the Colours table to the existing table and show the
colour in a text box control on the form. You can position this as a patch
at one end of the row or behind and around other control(s) to create a
background. Experiment to find what suits you best.
 
Top