Conditional Formating for Null Fields only highlights when record cell is clicked (1 Viewer)

[Minddumps]

SOLVED--SEE BELOW TRAFFIC

So, change to expression Is and then IsNull([YourFieldNameInBrackets])

&

choose "Expression Is" and in the box to the right put: IsNull(FieldName.Value)

&

'Place this on the onformat of detail properties

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If IsNull(Last BN Inspection Date) Then
Me.ControlName.BackColor = RGB(255, 0, 0)
Else
Me.ControlName.BackColor = RGB(0, 0, 0)
End If
End Sub

Hi everyone, I am trying to accomplish null values being changed to red in my report. I used the above quoted advices that I found through my searches, but the cells don't highlight unless the mouse is clicked on it. (whereas I was hoping they would automatically show in report view and printpreview view)

Is there a different approach needed for Access 2007 to get the background to change upon load rather than onfocus?

 

[Minddumps]

Great news for anyone looking for this answer!!

When in conditional formatting, you have to set the default formatting as well (it's not automatically done for you)! Awesome!