Have Geek Brain

MS Access Force signature at the bottom of the page

I am trying to make a report for a proposal. I would like to keep a professional look and always force the terms section at the bottom of the page. I could use a page footer, but I only need the conditions to appear on the last page.

My idea is somehow with VBA to set the height of the dummy group so that it forces the report footer to the bottom. The problem is that you cannot explicitly set the height of the section.

Anyone else with a different idea (what works)? :-)

Thanks, Jeff

+2


source to share


2 answers


This did the trick for me:

Private Sub PageHeaderSection_Format(Cancel As Integer, FormatCount As Integer)
Me.PageFooterSection.Visible = (Me.txtPage <> Me.txtPages)
End Sub


Thank you for your help.

+1


source


Here is the idea:
http://bytes.com/topic/misc/answers/499733-report-footer-location-problem#post1939746

To place reports one page at a time, you can do something like



If Me.Pages > 0 Then
Me.Section(4).Visible = (iif(Me.Pages = 1, True, Me.Page = Me.Pages))
EndIf

Note that Access only calculates the page count if your report has page numbers. If you don't want them to be displayed, you can set your Visible property to False.

+1


source






More articles:


All Articles