强制报表页脚位于页面底部 [英] Force Report Footer to be at bottom of page

问题描述

在Microsoft Access 2007中，

In Microsoft Access 2007,

是否可以在最后一页的底部显示报告页脚"部分?现在，我的报表页脚"部分始终位于详细信息"部分之后，因此它可以随处结束.

Is there a way to display the Report Footer section at the bottom of the last page? Right now my Report Footer section always follows my Detail section, so it ends up anywhere.

我想尽可能避免使用VBA.

I would like to avoid using VBA as much as possible.

推荐答案

是否必须是报表页脚，还是要求文本在报表最后一页的页面底部显示?如果是这样，那么只需很少的VBA即可完成:

Does it have to be the report footer, or is the requirement that you wish text to appear at the bottom of the page on the last page of the report? If so, then it can be done with very little VBA:

Private Sub PageFooterSection_Format(Cancel As Integer, FormatCount As Integer)
If Page = Pages Then
   Me.[TextBoxName].Visible = True
Else
   Me.[TextBoxName].Visible = False
End If
End Sub

这个想法是，您将一个文本框放在页面页脚中，只在最后一页上显示该文本框.

The idea is that you place a textbox in the page footer and only make it visible on the last page.

此外，您可能希望阅读 http://support.microsoft.com/kb/208979/zh-CN

In addition, you may wish to read http://support.microsoft.com/kb/208979/en-us

这篇关于强制报表页脚位于页面底部的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！