Actually, you can hide a control using Conditional Formatting, you just have to be tricky and change the Fore color if the condition is met! But you can't use CF for anything with checkboxes, so you need to be tricky again. There may be a slicker way to do this, but this will work!
First off, create a small rectangle and place it over each checkbox. Name them chk1Cover, chk2Cover and chk3Cover. Set their
Border Style to
Transparent. Now place this code behind your report:
-
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
-
If Me.chk1 = 0 Then
-
Me.chk1Cover.Visible = True
-
Else
-
Me.chk1Cover.Visible = False
-
End If
-
-
If Me.chk2 = 0 Then
-
Me.chk2Cover.Visible = True
-
Else
-
Me.chk2Cover.Visible = False
-
End If
-
-
If Me.chk3 = 0 Then
-
Me.chk3Cover.Visible = True
-
Else
-
Me.chk3Cover.Visible = False
-
End If
-
-
End Sub
Linq
;0)>