VBA - if then else to set bgcolor

[pmsbony]

I have a form that displays a list of records from a table.

Based on the entry in one of the fields I want to set the bgcolor of that specific field to either red or green.

the code i am using is:

If Call_Status = "open" Then
Call_Status.BackColor = vbRed
Else: Call_Status.BackColor = vbGreen
End If

this does not seem to work. Any ideas what I am doing wrong. Also at what point should the code run? when the form loads or opens, before update on that specific field or another time. All help will be rewarded with good vibes sent in your general direction

cheers

Pete

 

[PHV]

Have you tried conditional format ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[pmsbony]

worked like a charm - ta very much

the vibes are heading your way