On Wed, 16 Nov 2005 10:38:16 -0800, Glo wrote:
> 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.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7562
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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=7562
header
X2 = X1
Y2 = Me.ScaleHeight ' set length of line
Me.Line (X1, Y1)-(X2, Y2)
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
Our Donation Goal
: Why Donate? : Donate Today! : Donate Anonymously (ਗੁਪਤ) : Our Family of Supporters 
Linear Mode
