Report Footer Question

  • Thread starter Thread starter Don Rountree
  • Start date Start date
D

Don Rountree

I have a report that can grow in length, depending on how
many detail lines are in the report. I have a customer
signature line in the report footer. If there are only a
few lines of detail, the signature line is up in the
middle of the report. Is there a way I can keep the
report footer at the bottom of the page or bottom of the
last page if there are multiple pages? I only need one
instance of this line, so it is not prudent to put it in
the page footer section in case there are multiple
pages. Thanks for any help you can give me.

Don Rountree
 
Don said:
I have a report that can grow in length, depending on how
many detail lines are in the report. I have a customer
signature line in the report footer. If there are only a
few lines of detail, the signature line is up in the
middle of the report. Is there a way I can keep the
report footer at the bottom of the page or bottom of the
last page if there are multiple pages? I only need one
instance of this line, so it is not prudent to put it in
the page footer section in case there are multiple
pages. Thanks for any help you can give me.
Click to expand...

There are a couple of techniques that can be used to push
the report footer section down the page, but they're a
little messy and not worth it if the footer is fairly
simple. Take a look at using the report's Print and Line
methods in the Page event instead. You will have to have a
text box in the page header or footer that refers to Pages
so that the code can tell when it's on the last page.
Here's the general idea:

If Me.Page = Me.Pages Then
Me.Line (3.5 * 1440, 9.8 * 1440) - STEP(3 * 1440, 0)
Me.FontName = "Times Roman"
Me.FontSize = 8
Me.CurrentX = 4 * 1440 ' 4 inches from left
Me.CurrentY = 10 * 1440 ' 10 inches from top
Me.Print "Signature"
End If
 
Back
Top