vertical lines in multicolumn subrpt

[John G]

How do you draw vertical lines on a multicolumn subreport. I only want two
vertical lines. One on the left side of the report and the other on the
right. The Line method places the vertical line on the left side of the page
(as it should) but the right vertical line is placed on the right side of the
first column of data. The Line method works good on single column subreports.
Is there a way of using it on multicolumn subreports?
Thanks.

 

[banem2]

How do you draw vertical lines on a multicolumn subreport. I only want two
vertical lines. One on the left side of the report and the other on the
right. The Line method places the vertical line on the left side of the page
(as it should) but the right vertical line is placed on the right side ofthe
first column of data. The Line method works good on single column subreports.
Is there a way of using it on multicolumn subreports?
Thanks.

Not sure what you want to do - could you simply draw two vertical
lines in subreport details section - one one the left side and second
right of the last subreport field? Something like:

| Field1 Field2 Field3 |

Make the line height match details section height and they will repeat
for each record making it like continuous lines.

Regards,
Branislav Mihaljev
Microsoft Access MVP

 

[Duane Hookom]

Can the lines be drawn on the main report at the left and right of the
subreport? If so, you can use the Line method (code) in the On Print event of
the section of the main report that contains the subreport.

 

[John G]

I'm sorry but I failed to mention that there are several subreports on a main
report and that the detail section of the subreports can grow (and shrink).
Detail sections of some subreports require a box and others require just a
vertical line on each side. Line method works on all the single column
subreports for the various lines, but doesn't draw the right vertical line
where I want it on the multicolumn subreports.

 

[John G]

Duane,

The lines can not be drawn on the main report on the left and right side of
the subreport. I'm sorry but I failed to mention that there are several
subreports on a main report and that the detail section of the subreports can
grow (and shrink). Detail sections of some subreports require a box and
others require just a vertical line on each side. Line method works on all
the single column subreports for the various lines, but doesn't draw the
right vertical line where I want it on the multicolumn subreports.

 

[Duane Hookom]

I expected the subreports would be "growable" which could be handled by the
code in the main report. I don't understand why the solution wouldn't work
for the multicolumn reports. Don't you basically want either a border around
the entire subreport or a border minus the top and bottom lines?

 

[John G]

Duane,

Yes, what I want for some subreports is a border and others I want a border
minus the top and bottom lines. The problem is with multicolumn subreports
where the right vertical line is drawn on the right side of each column
instead of the right side of the detail section. I do not want any columns
divided by any vertical lines. The sections right vertical line doesn't get
drawn for some reason but the columns are divided by vertical lines. I hope
this makes sense.

 

[Duane Hookom]

I think you didn't understand my initial reply. I suggested the code using
the Line method should be in the On Print event of the main report, not the
subreport.

 

[John G]

I tried using the Line method in the details section of the main report but
the line only shows where there are no subreports. The subreport borders are
set to transparent. I would have thought the line would go right through the
subreports but it doesn't appear to. What is it that I'm doing wrong?
Thanks Duane

 

[Duane Hookom]

Maybe you should share your code? If the lines don't show, subtract a few
twips from the X of the left line and add a few to the X of the right line.

 

[John G]

Here is the code Duane,

Me.Line (0, 0)-Step(0, Me.Height)
Me.Line (Me.Width, 0)-Step(0, Me.Height)

I can't seem to get the right vertical line to show when this code is placed
in the Detail Print event of the main report. So, what I did was placed a
multicolumn subreport in the details section of a single column subreport
which has the above code in the On Print event and the lines are drawn where
I want them. There are no vertical lines dividing the columns. This is just
what I wanted.

Thanks for all your time. I appreciate it.