How can I make lines grow and shrink

[Guest]

In an Access 2000/2002 report, how can I make a line that I put in the detail
section, grow and shrink as a text box grows? I have drawn some vertical
lines that span the height of the detail section, but when my text box that
is in my detail section grows, my vertical line does not grow.

 

[Allen Browne]

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

 

[Marshall Barton]

In an Access 2000/2002 report, how can I make a line that I put in the detail
section, grow and shrink as a text box grows? I have drawn some vertical
lines that span the height of the detail section, but when my text box that
is in my detail section grows, my vertical line does not grow.

Not clear. It sounds like you have placed Line controls
(vertically) in the detail section, when what you need to do
is draw the lines using the Line method in the section's
Print event procedure.

I don't know where you wnat the line(s?) positioned, but
here's a simple example you can adapt to your situation:

Me.Line (2.3 * 1440, 0) - Step(0, 20 * 1440)

where the 2.3 is the number of inches from the left margin
(the Left property of line you have now). The 20000 is how
long the line is, but you don't need to figure that out
because it will be croppped at the section boundary. The
1440 is the number of twips per inch, which is needed to
convert your inch measurements to Access's internal units.

 

[Guest]

Marshall, thank you very much...for what I needed, this was perfect.

 

[JohnLute]

This is an oldie but a goodie! Thanks, Marshall!