Resize Group Footer using VB

[Brian]

I would like to resize a group footer based on data that
is or isn't on the report. How can I do this using VBA?
I know that you can't resize if there is a control in the
footer. So I have a process that will remove controls.
Now I need to be able to resize the footer height to 0.
Any help would be appreciated.

 

[Marshall Barton]

I would like to resize a group footer based on data that
is or isn't on the report. How can I do this using VBA?
I know that you can't resize if there is a control in the
footer. So I have a process that will remove controls.
Now I need to be able to resize the footer height to 0.

Given the question, I think you must be using AXP or or
newer.

I don't know what you mean by "remove" controls, but it is
probably unnecessary. You can reduce the height of the
section, but not so much that it would chop off a control.
OTOH, you can set the Top (and/or Height) property of the
controls (so that they move up out of the way of the bottom
of the section) before you reduce the height of the section.

As to your question of making the section height 0, instead
of messing around with all that stuff, just make the section
invisible.