Vertical lines growing in a report.

[DonS100]

Hello, I have a report in Access 97. There are vertical lines in the detail section that are between text boxes. The text boxes are set to grow, so when the data wraps to the next line, you have have space in the vertical line. How do you get the vertical line to grow with the text box.

Thanks

Don

 

[Remou]

Hi
If the text box was related to the line by including the name of the textbox in the tag property of the line:

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Me.Line2.Height = Me(Line2.Tag).Height
End Sub

Or maybe just draw lines for each control:

Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)
    Dim CTL As Access.Control
    For Each CTL In Me.Detail.Controls
        Me.Line (CTL.Left, CTL.Top)-(CTL.Left, CTL.Top + CTL.Height), RGB(0, 0, 0)
    Next
    Set CTL = Nothing
End Sub

Then there is:
Vertical lines in rpt where fields can grow/shrink
thread705-1055670