Selcting Multiple Fields in a Event Procedure

[Dilly]

I have created a report that use the following code to format a field :-

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If IsNull([Qty Rec]) = True Then
Me![Current Date].ForeColor = vbRed
Else
Me![Current Date].ForeColor = vbBlue
End If

End Sub

This works OK for the one field but how do i do this to highlight multiple field or maybe the whole line.

 

[CosmoKramer]

I don't know a way of automatically doing that for all fields on the detail line. I think you will have to change the color individually for all. BackColor can be changed for the detail line, but make sure that your text boxes' BackStyle property is set to Transparent......