Full Version: Referring To Group Footer .visible Property In Vba
UtterAccess Discussion Forums > Microsoft® Access > Access Reports
BobRoss
Hello:

I was wondering if anyone knows the syntax for referring to the .visible property of a group footer from the OnLoad event.

I would like to do this from the OnLoad event, because I need to work with more than one group and want the code for this to be all in one place instead of separating it into the OnFormat event of each individual group.

Thanks!
BobRoss
BobRoss
Forgot to mention that I also need to know how to refer to the report footer as well.
pere_de_chipstick
Hi bobRoss
Try

Me.GroupFooterN.visible = BolVis
where BolVis is a boolean variable -1 true, 0 False
and N is the group footer number e.g.

Me.GroupFooter0.visible = BolVis
Me.GroupFooter1.visible = BolVis

and

Me.ReportFooter.visible = BolVis



hth
BobRoss
pere,

That's exactly the information I was having trouble finding! Everything worked out very well!

Thanks!
BobRoss
pere_de_chipstick
yw.gif
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.