Column Lines

[Alex Motilal]

Hello everyone,



In Reports I am using the following code on the Print Event to draw vertical column lines:

Me.ScaleMode = 1
Me.ForeColor = 0

Me.Line (0 * 1440, 0)-(0 * 1440, 14400)
Me.Line (2 * 1440, 0)-(2 * 1440, 14400)
Me.Line (4.16666 * 1440, 0)-(4.16666 * 1440, 14400)
Me.Line (5.08333 * 1440, 0)-(5.08333 * 1440, 14400)
Me.Line (6 * 1440, 0)-(6 * 1440, 14400)
Me.Line (7 * 1440, 0)-(7 * 1440, 14400)

The above code draws Solid Line of 1 Point. Is it possible to draw Solid Lines of different thickness (say 2 Point) and also is it possible to draw doted lines or dashes?

With thanks,
Alex

[June7]

Yes. Check out this article http://msdn.microsoft.com/en-us/libr...ffice.11).aspx

Set the DrawWidth, DrawStyle, DrawMode properties before the lines you want those properties to influence. Like:
Me.DrawWidth = 2
Me.DrawStyle = 3
Me.Line (0 * 1440, 0)-(0 * 1440, 14400)
Me.Line (2 * 1440, 0)-(2 * 1440, 14400)

[Alex Motilal]

Thank u June7,
Your solution works fine.
Alex