Conditional formatting

How can I use conditional formatting to have a field change background colors if it is populated or stays white if left blank. Do I use field value, field has focus or expression.

You can use Event Procedure "On Current" by



Private Sub Form_Current()

If IsNull(Text0) Then

Me.Text0.BackColor = 16777215 'White

Else

Me.Text0.BackColor = 255 'Red

End If

End Sub