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