Blank detail section

[Guest]

I have a report called Invoice.
This report should have an A4 sheet size. So, I am working only with page
header, footer and detail section.
When the detail section has only one record there is a blank space between
the detail and the footer section.
I would like to fill this blank space with the vertical lines, as in the
detail section. So, it will seem that detail section reach page footer
section, but with no records.

Any ideas on how to accomplish this?

 

[Duane Hookom]

Use code in the On Page event of the report like:

Private Sub Report_Page()
'draw a vertical line along the left margin
Me.Line (0, 0)-Step(0, 20000)
'draw a vertical line 1 inch from the left margin
Me.Line (1440, 0)-Step(0, 20000)
'draw a vertical line 2 inches from the left margin
Me.Line (2880, 0)-Step(0, 20000)
End Sub

 

[Guest]

thank you Duane

"Duane Hookom" escreveu:

Use code in the On Page event of the report like:

Private Sub Report_Page()
'draw a vertical line along the left margin
Me.Line (0, 0)-Step(0, 20000)
'draw a vertical line 1 inch from the left margin
Me.Line (1440, 0)-Step(0, 20000)
'draw a vertical line 2 inches from the left margin
Me.Line (2880, 0)-Step(0, 20000)
End Sub