gap in my report

[Guest]

I am recreating a report that has a border around each page and every column
is separated by vertical lines. I have a gap in the vertical lines in every
column between the DETAIL and PAGE FOOTER sections, and I need the lines to
connect and appear as they are a continuous lines. Also, the last page has
white space between the last record and PAGE FOOTER, but again, I need a
continuous line to go from the first record down to the PAGE FOOTER. Is there
a way to do this? Perhaps inserting blank records (though this doesnt solve
the gap issue).

Please help!

 

[Marshall Barton]

I am recreating a report that has a border around each page and every column
is separated by vertical lines. I have a gap in the vertical lines in every
column between the DETAIL and PAGE FOOTER sections, and I need the lines to
connect and appear as they are a continuous lines. Also, the last page has
white space between the last record and PAGE FOOTER, but again, I need a
continuous line to go from the first record down to the PAGE FOOTER. Is there
a way to do this? Perhaps inserting blank records (though this doesnt solve
the gap issue).

Draw the vertical lines using the Line method in the Page
event, much like what I expect you're using to draw the
border around each page.

 

[Guest]

Draw the vertical lines using the Line method in the Page

event, much like what I expect you're using to draw the
border around each page.

Actually, the border is part of the problem and is behaving the same way. I
see that I did not use most effective way to draw these lines.

How do I use a line method? Do I go into the Design View, click on the Event
tab, and build code?

Thanks so much for your response. I'm on my way...!

 

[Marshall Barton]

Actually, the border is part of the problem and is behaving the same way. I
see that I did not use most effective way to draw these lines.

How do I use a line method? Do I go into the Design View, click on the Event
tab, and build code?

Yes, you use design view and the code builder in the
Report's Event Properties for the OnPage property.

I would love to be able to tell you to RTFM about how to use
the Line method, but, since A2K, Help is completely messed
over in its description of Line.

I'll try a couple of examples to get you started:

Draw a border around the entire page:
Me.DrawWidth = 20 'line thickness
Me.Line (0,0)-(Me.ScaleWidth-15, Me.ScaleHeight-15), , B

Draw a vertical line at the right edge of the text box named
text0:
Me.Line (Me.text0.Left + Me.text0.Width,0)-
Step(0, Me.ScaleHeight-15)

Draw the border below the page header and above the page
footer:
Me.Line (0, Me.Section(acPageHeader).Height)-
(Me.ScaleWidth - 15, Me.ScaleHeight -
Me.Section(acPageFooter).Height - 15), , B

The 15 is just a fudge factor to prevent the line width from
extending beyond the page boundaries.