control to be visible with only first member of group

[iampaul]

I have a report which has a number of group headers. The detail is sorted on 2 fields. In the detail section section i have a number of rectangles which will form check boxes for users to tick on a paper report. I only want the boxes to be visible on the first record in each group.

Does anyone know how I can identify the first record in each group to use in code like that showed below.

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)

If first record in group = true
Then
Me.Box1.Visible = True
Me.Box2.Visible = True
Me.Box3.Visible = True
Else
Me.Box1.Visible = False
Me.Box2.Visible = False
Me.txtBox3.Visible = False
End If

End Sub

 

[iampaul]

Problem solved. Have added a invisible text box with a running sum across the group. Have then made boxes visible if value in text box = 1.