A set size for detail section

[Patricia]

I have a report I have grown vertical lines in for the detail section. My
detail section should be about 5" max, but some of the reports only have
about 3 lines of info. I would like the lines to go all the length of the
detail section whether there is info or not. Can I do that?

 

[Allen Browne]

See Stephen Lebans' solution here:

http://www.lebans.com/PrintLines.htm

 

[Stefan Hoffmann]

hi Patricia,

I have a report I have grown vertical lines in for the detail section. My
detail section should be about 5" max, but some of the reports only have
about 3 lines of info. I would like the lines to go all the length of the
detail section whether there is info or not. Can I do that?

You need to set the size (height) of your lines in the print event:

Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)

Dim ctl As Access.Control

For Each ctl In Me.Controls
If TypeOf ctl Is Line Then
Me.Line (ctl.Left, 0)-(ctl.Left, 10000), 0
End If
Next ctl

End Sub

I have only vertical lines, so this works for me.


mfG
--> stefan <--