me.line format

[Guest]

I have used some code "Me.Line (x, y) - Step(0, 20000)" from another post to
create dynamiaclly sized vertical lines in the detail section print event on
a report "Me.Line (x, y) - Step(0, 20000)". It works great, except I want a
few of the lines to be 2pt instead of hairline to match the header lines.
Can I set the line format within the me.line code?

 

[Guest]

Me.LineName.BorderWidth = 2

 

[Guest]

Thanks, Dave: I'm not sure how to name the line since it is not in design
view; but only in print event. Example of code to be at 2pt is below.

Me.Line (Me.Ten_Closed.Left, 0)-Step(0, 20000)

What should I do?

 

[Guest]

Well, I have never used that technique, so I am not sure how to handle that.

 

[John Spencer]

Look up DrawWidth in the VBA Help. Help says that the number represents
PIXEL

Me.DrawWidth = 5
Me.Line (Me.Ten_Closed.Left, 0)-Step(0, 20000)

'Change the line width
Me.DrawWidth = 2
Me.Line (Me.Ten_Closed.Left, 0)-Step(0, 20000)


--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

 

[Marshall Barton]

Thanks, Dave: I'm not sure how to name the line since it is not in design
view; but only in print event. Example of code to be at 2pt is below.

Me.Line (Me.Ten_Closed.Left, 0)-Step(0, 20000)

What should I do?

For the line method, use:

Me.DrawWidth = 2
Me.Line . . .