Counting Detail Records by Group

[Paul H]

I'm brushing up on my report design chops and I'm stubbing my toe on something simple. I was a count of how many records are in each detail section and I can't remenber how to do it. If the record count = 0 then I want to run some code.

Hope you can help,

Thanks

[June7]

What do you mean by 'each' detail section? A report has only one Detail section. Do you mean group section?

Perhaps you need to apply a filter to report so do not have groups without records.

Provide more information on what you are trying to accomplish so that we can better advise.

[Paul H]

OK, I have 3 controls in a group header, two labels and a line that I want to hide if there is no detail.

BTW I couldn't find the HasData event and Access Help came up empty.

[Paul H]

I found the HasData of the Report, but I'm still not sure how or where to use it to accomplish the above task.

[June7]

I removed my comments about HasData after re-reading your post.

You might try the OnFormat event of the group header. I have done this in Detail section OnFormat event, never tried for group.

If IsNull(Me!somefieldname) Then
Me.controlname.Visible = False
End If

There will be blank space on report occupied by the invisible control. Can't reduce the blank area because controls are still there.

[Paul H]

I tried tried this code in OnFormat of the header. txtCount uses =Count([Product_ID]) as a Control Source. Product_ID is a text box in the detail section.

        With Me
    If .txtCount = 0 Then
           .Line_Grandchild.Visible = False
           .lblGrandchild.Visible = False
           .lblUPC.Visible = False
        End If
    End With

I can't get the code to run. I put a break in to catch and got nothing and also a msgbox. I tried On Paint. The code ran, but you can't change those properties in the OnPaint event.

[June7]

I think the code will execute only when report is in PrintPreview or sent directly to print. All I know is that OnFormat works for Detail section. Never used OnPaint or OnPrint.

[Paul H]

Of course I knew that or should have. The report is starting to come around. These growing pains are making me old(er).

Thank you.