Line between columns

[Guest]

In my report detail view, I drew a line to the left of the fields. When I
view the report it puts the line between the columns and an extra one off on
the right margin. Is there another way to do this that would make the line
part of the page setup rather than the "detail" portion of the report?

I ask because while I can accept the extra line on the right margin, some of
my fields have wrapped text. As the line is only set to be the height of the
orignial field, it means that the line between columns often has breaks in it
as it goes down the page.

Any ideas would help!

 

[Allen Browne]

It will probably be easier to draw the line programmatically.

Use the Line statement in the Page event procedure of the report.

 

[Guest]

(VBA's all new, so forgive if this is a newbie question)

Is it really the page event? I only want the line between columns in the
detail section of the report. Headings and Footers don't need to be slit.

 

[Allen Browne]

The Page Header and Page Footer sections are fixed height, i.e. they do not
have Can Grow or Can Shrink properties. Therefore you can calculate at
design time where the line should start (below the Page Header) and where it
should end (above the Page Footer.)

Or perhaps you have group headers/footers interspersed throughout the page,
and you don't want the vertical line to slice through them? If so the Page
event is not suitable. Stephen Lebans has a routine for drawing the lines
like that at:
http://www.lebans.com/PrintLines.htm
I'm not sure how you would hide them at the right margin though.