Well, I've looked through the archive and haven't found a solution. I'm trying to use the following code to hide/unhide report controls based on specific criteria. Curiously this same method works just fine on a different report.
Any help with this is much appreciated.
Code:
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If Me!txtXLst = "" Or IsNull(Me!txtXLst) Then
' Display/hide cross list information
Dim ctl As Control
For Each ctl In Me.Controls
If ctl.Tag = "Visible" Then ctl.Visible = False
Next ctl
Else
For Each ctl In Me.Controls
If ctl.Tag = "Visible" Then ctl.Visible = True
Next ctl
End If
End Sub
Any help with this is much appreciated.