I need to skip a detail row in an Access report when one of the detail values is null. I can't change the query that feeds the report to eliminate the null rows for reasons I won't go into here.
I saw this solution in another post:
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If Me.MyID = 1 Then Cancel = True
I added this to the report code, but it does not seem to get called. I even changed to condition to if 1=1 then cancel = true, but it still did not work.