Hide rows if isnull(field)

[sangathy]

I am trying to hide certain rows on the detail section of a report if the field value is null

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If IsNull(contact_date) And action = "" Then
Me.action.Properties("Visible") = False
End If
End Sub

but this hides the Action field through out the report. Any idea on how to hide rows( some are empty fields and some fields have value)

thanks

 

[Remou]

If you wish to hide an entire row, it may be best to either edit the query on which the report is based, or open the report with a Where clause. If you wish to hide a Control, you may wish to look at Conditional formatting.

 

[sangathy]

Thanks Remou.