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?
--
THX

[Allen Browne]

See Stephen Lebans' solution here:

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

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Patricia" <Patr...@discussions.microsoft.com> wrote in message
news:B7E6CB5A-E9ED-4F02...@microsoft.com...

[Stefan Hoffmann]

hi Patricia,

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