Add signatures at the end of a report

[Johanvdw]

Hi there,
I need some help with a report (delivery note). I need to put the recipient and his signature at the end (bottom of the page) of the report. Sometimes if have only 1 item to deliver (1 page) and the the receiving part floats to the middle of the page. Sometimes I have a couple of pages of items, and I don't want the receiver to sign on very page, but only on the last page (at the bottom of the page). I hope this make sense and somebody can help me.

 

[CJ_London]

Perhaps use the report footer?

 

[Johanvdw]

I have done that, but if the last page is only half full, it still floats to the middle. I want the names, signatures and dates at the bottom of the page. Can this be done?

 

[CJ_London]

See this link

Force Report Footer to be at bottom of page

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 any...

stackoverflow.com

 

[arnelgp]

you can do it on the PrintPreview of the report (only).
plus you you will have extra space on the bottom.
see Order report (Detail_Format vba).

 

[Ken Sheridan]

I have done that, but if the last page is only half full, it still floats to the middle. I want the names, signatures and dates at the bottom of the page. Can this be done?

If you put the controls in the page footer you can show them only on the final page with code like this in the page footer's Format event procedure:

Dim blnShowControl as Boolean

blnShowControl = (Page = Pages)

Me.txtName.Visible = blnShowControl
Me.txtSignature.Visible = blnShowControl
Me.txtDate.Visible = blnShowControl

If you need to keep the page footer smaller on the preceding pages the methods posted above by others allow this.