Hide Report Controls in Report Footer

[scott]

I have about 8 label, 8 textbox controls plus a subreport in my report
footer. In the OnFormat event, I know I can set each control's visible
property to false if I need to.

Is there a way to iterate through the report footer and set the visible
property of any control found to false or true?

 

[fredg]

I have about 8 label, 8 textbox controls plus a subreport in my report
footer. In the OnFormat event, I know I can set each control's visible
property to false if I need to.

Is there a way to iterate through the report footer and set the visible
property of any control found to false or true?

Do you want to change just the ones that are False to True?
Code the Format event of that section:
Dim c as control
For each c in Me.Section(2).controls
If c.Visible = False Then
c.Visible = True
End If
Next

Or do you wish to set the ones that are False to True and the ones
that are True to False.

Dim C as Control
For each c in Me.Section(2).controls
c.Visible = Not c.Visible
Next

 

[scott]

i have a report form filter that allows the user to choose an option of
displaying All Records or just a specific one. When they choose the "All"
option, I needed to hide everything in the report footer because that's
where i show a combined total section that should only show when the "All"
option is chosen.