使用VBA创建动态报表页脚 [英] Create Dynamic Report Page Footers with VBA

问题描述

我需要创建一个Access报表，其第1页上的页脚与第2页上的页脚不同。有没有办法根据正在呈现的页面动态分配页脚中的内容？有没有办法根据其中包含的内容动态调整每页页脚
高度？

I need to create an Access report that has a different page footer on page 1 than is on page 2 thru whatever. Is there a way to assign what is in the page footer dynamically based on which page is being rendered? Is there a way to adjust each page footer height dynamically based on what is included in it?

推荐答案

是和是的。而且，它可以以各种方式完成。例如，你可以将两个页脚垂直放在一起（我不想混淆任何人说"在彼此的顶部"）并将高度设置为零（0）或几乎为零，但使用Can
将属性设置为是。然后，您可以使用代码根据页码或位置显示或隐藏每个页脚。

Yes and yes. Also, it can be done in various ways. For example, you can place the two footers next to each other vertically (I didn't want to confuse anyone by saying 'on top of each other') and set the height to zero (0) or almost zero but with the Can Grow property set to Yes. Then, you can use code to show or hide each footer based on the page number or location.

只需2美分......

Just my 2 cents...

这篇关于使用VBA创建动态报表页脚的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！