Draw a continuous verticle line in a report between two columns.

[Guest]

I want to draw a continuous verticle line in a report between two columns of
data, but the ling breaks where the cell data wraps. Is there a way to
control the placement of lines where there is no break?

 

[fredg]

I want to draw a continuous verticle line in a report between two columns of
data, but the ling breaks where the cell data wraps. Is there a way to
control the placement of lines where there is no break?

Look up the Line method in VBA help.
Place the code in the report's Page event, not the detail event.

Adjust the argument values as needed.

Dim X1, Y1, X2, Y2 As Single
Me.DrawStyle = 0
Me.DrawWidth = 1 ' set the thickness of the line
' Set the coordinates and draw a line down the middle of the page.
X1 = Int(Me.ScaleWidth / 2) ' find the middle of the page
Y1 = Me.Section(acPageHeader).Height ' start just below the page
header
X2 = X1
Y2 = Me.ScaleHeight ' set length of line
Me.Line (X1, Y1)-(X2, Y2)

 

[Trina Jackson]

I want to draw a continuous verticle line in a report between two columns of
data, but the ling breaks where the cell data wraps. Is there a way to
control the placement of lines where there is no break?

this is not your right email adress

do not send anything to me again