Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Multiple Line Fields In Report

Status
Not open for further replies.

greetingsc

IS-IT--Management
Jan 2, 2004
1
US
I have a report with multiple columns, some single line, and some multi-line. There is vertical lines on the report, but no horizontal lines (so borders can't be used on text boxes). The problem is the lines don't grow when the fields have multiple lines and thus there are gaps in the lines.

Does anyone have any clue what could be done?, Is setting line height by code possible based on the details sections height?

Thanks,
Michael
 
Hi
This might help:
Code:
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
(acknowledgements to D Hookum)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top