Can grow vertical lines?

[Guest]

I posted a question about a week ago about can grow vertical lines. Someone
posted a link to someone that has set up a database that does that but I
can't figure out all the code to make it work. Is there something I can
import into my database or copy and paste in a module? Basically I can't
figure out what all that code means, and cant get it to work.

 

[Gina Whipp]

Ummm, what was the link or the database? No one here can see what code
you're refering to to make suggestions.

 

[Guest]

Someone sent me this link: www.lebans.com There is a database you can
download that has the code for it

 

[Guest]

Sorry about that

http://www.lebans.com/PrintLines.htm

 

[Gina Whipp]

Okay, which database, there are quite a few there.

 

[Gina Whipp]

Is it the PrintLines? Is this the code you are refering to?

Me.ScaleMode = 1
Me.ForeColor = 6723891

'Repeat the following line of code for each vertical line
' 1*1440 represents 1 inch
Me.Line (0 * 1440, 0)-(0 * 1440, 14400) 'Draws line at Left Margin
Me.Line (0.6667 * 1440, 0)-(0.6667 * 1440, 14400)
Me.Line (1.4583 * 1440, 0)-(1.4583 * 1440, 14400)
Me.Line (2.25 * 1440, 0)-(2.25 * 1440, 14400)
Me.Line (3.5833 * 1440, 0)-(3.5833 * 1440, 14400)
Me.Line (7.4167 * 1440, 0)-(7.4167 * 1440, 14400)
Me.Line (8.25 * 1440, 0)-(8.25 * 1440, 14400)
Me.Line (9.1667 * 1440, 0)-(9.1667 * 1440, 14400)
Me.Line (10 * 1440, 0)-(10 * 1440, 14400)

'the 14400 is an arbitrary number to increase the line to the max of a
'section.

 

[Gina Whipp]

I am looking at that one but what about the code I provided below. I am
desperately trying to figure out WHERE I got it (Maybe someone watching this
thread will know) but it works for vertical lines. I put it on the
Detail_Format of my report.

 

[Gina Whipp]

Okay, I got my code from here: http://support.microsoft.com/kb/q208429/ no
modules, just like the sample code I sent to you.

 

[Guest]

Thanks!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

 

[Gina Whipp]

You're most welcome!

--
Gina Whipp

Thanks!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!