Adjust Line Height in Detail 1

[perrymans]

I want to make the vertical line in my access report grow and shrink with the detail record.

There are multiple records in the detail per grouping, each with a different hieght.

I tried lngHeight = Me.txtBox.Height but it just sets the line to one height, it doesn't adjust for each different record height.

Thanks. Sean.

 

[dhookom]

I would use code in the On Print event of the detail section to draw the line. For instance to draw green and red lines at the left and right margins of the report

    Me.Line (0, 0)-Step(0, Me.Height), vbGreen
    Me.Line (Me.Width, 0)-Step(0, Me.Height), vbRed

Duane
Hook'D on Access
MS Access MVP