View Single Post
Old 11-05-2004, 08:49 PM   #5
WayneRyan
AWF VIP
 
Join Date: Nov 2002
Location: Camarillo, CA
Posts: 7,091
Thanks: 6
Thanked 59 Times in 56 Posts
WayneRyan is a jewel in the rough WayneRyan is a jewel in the rough WayneRyan is a jewel in the rough WayneRyan is a jewel in the rough
s,

You can use the DetailFormat event:

Code:
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Dim i As Integer
For i = 0 To Me.Controls.Count - 1
   If Me.Controls(i).ControlType = acCheckBox Then
      If Me.Controls(i) Then
         Me.Controls(i).Visible = True
      Else
         Me.Controls(i).Visible = False
      End If
   End If
   Next i
End Sub
Wayne
WayneRyan is offline   Reply With Quote