Full Version: Using CanGrow in a footer
UtterAccess Discussion Forums > Microsoft® Access > Access Reports
Capellan
Hi all,

I have a report that has a section in the footer for a memo field from a table. I have it set with CanGrow because it could be nothing or it could be many lines. The problem is that it is pushing other fields in my footer off the page instead of pushing up and forcing detail items onto a new page. Is there any way around this?
MCzopek
Capellan

The problem is that while your memo field is set to grow, the footer itself doesn't have that property, so the space it takes up is fixed.

If you're able to arrange your report in a way that you can create a grouping, you can create a group footer which you can set to grow.

HTH,

Mike
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.