Hello

Is there a way to change the colour of the background of a form based on the value of a field?

Something like:

If Status = "Closed" Then
BackColor = vbRed
ForeColor = vbYellow
End If



But that doesn't work!

Many Thanks