Conditionally hide detail row in report

[martinjamesward]

I am attempting to hide the detail section of a report conditionally.

I want to hide all rows where the field trn_DaysModified is less than or equal to the field rty_TargetDays (hide all records in target)

My research suggest the following should work, but my report is still showing all rows (rows are also grouped by trn_DaysModified so i can count the number of records by trn_DaysModified)

Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)
    If Me.trn_DaysModified <= Me.rty_TargetDays Then
        Me.Detail.Visible = False
    Else
        Me.Detail.Visible = True
    End If
End Sub

Can someone please point out where I am going wrong?

[weekend00]

Maybe you can try to move the code to detail_format event.

[martinjamesward]

Have just tried that - still no joy

[weekend00]

Did you mean just filter away the rows which match you criteria and show the other rows? you should use a filter to do that.

[dynamictiger]

Sorry are you trying to make the detail section visible and not visible based on a value in teh detail section?

[martinjamesward]

What I am trying to do is hide a detail row if it passed a test

i.e.
if DaysModified is less than or equal to the TargetDays hide the row, otherwise show it.

I am nee to write a report which says this many repairs complete (therfore all records are valid), grouped by day complete which only shows the detail of the repairs outside target but still includes those on target for summaries.