Line between columns

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!

It will probably be easier to draw the line programmatically.

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

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"sduffield2" wrote in message
...
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!

(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" wrote:

It will probably be easier to draw the line programmatically.

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

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"sduffield2" wrote in message
...
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!

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.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"sduffield2" wrote in message
...
(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" wrote:

It will probably be easier to draw the line programmatically.

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

"sduffield2" wrote in message
...
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!