Page Footer + Can Grow

In Access 2000 I have a report. I need to put a sub report in the Page footer and set the sub reports "Can Grow" to yes.
However, it does not grow at run time!

How do I get it to grow?
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.


The subreport can grow, but not beyond the size of the footer. The page footer cannot grow. There is a trick for growing page headers, but not footers. You will have to set aside enough space for it.

TimTDPAuthor Commented:
What is the trick?
The trick is to add a dummy group, for example on the expression "=True" at the very top in "Sorting and Grouping". Then select Group Header: Yes, and, on the header itself, choose Repeat Section: Yes. That way, you get a second hand-made page header.

However, this doesn't work for footer.

Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

TimTDPAuthor Commented:
I have already done this.

It is the page footer I can't get right!
As I said, this is not possible. If you think about it, there is no way to implement growing page footers, either. Access (or any other page-formatting software) needs to know the size of the footer before it starts printing the page.

If you really need it, I see only this tweak (MDB files only):

 * Open report rptCheckSize, containing only a detail section with the same subreport
 * In Detail_Format, record the size of the subform control to a global variable
 * Open your rptPageFooterStunt report in _design_ view
 * Adjust the size of the footer (and while you are at it of the subform control)
 * Switch to report preview...

I have to say I keep wondering what makes you need a subreport in a footer anyway. Care to explain?


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
TimTDPAuthor Commented:
For a generic report for company documents.

I have different company's, each with their own header and footer details. I have reports for each company's header and footer, which are inserted as sub reports in the main report. At run time I change the source of the sub reports to reflect the correct company. I can never guarantee that the height will always be the same for each company, hence the "can grow" requirement.
Ah, ok. We did use that security scheme in one of project I was working on. However, we only inserted a fixed-size form as subform on the reports. (It was a form, so that we could display the same in the "About" box and some other forms...)

If you generate MDE files for your clients, you could run a function that will loop through all reports and adjust the page footers and save. Then generate the customized MDE.

If you distribute MDB files, you could include a tool in some options dialog: refresh reports for changed footer layout, so that they can do that themselves.

From what you describe, run-time adjustments are probably not a good idea...

Good luck!
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.