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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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?
Click to expand...

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)
 
Glo said:
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?
Click to expand...
this is not your right email adress

do not send anything to me again
 
Back
Top