Report Design

[Sue]

I added some border lines to my report design. and the
results did not seem preety, there is always a big gap for
the last page (only 2 or 3 rows )between the vertical line
(detail) and bottom line (page footer).


Is there a way to avoid this?

 

[Duane Hookom]

Don't use controls on your report. Try add code to the On Page Event of your
report:
Private Sub Report_Page()
Me.Line (0, 0)-Step(Me.Width, 12000), , B
End Sub
The 12000 will depend on the height of your report.