If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
gap in my report
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! |
#2
|
|||
|
|||
gap in my report
janet wrote:
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. -- Marsh MVP [MS Access] |
#3
|
|||
|
|||
gap in my report
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...! |
#4
|
|||
|
|||
gap in my report
janet wrote:
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? 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. -- Marsh MVP [MS Access] |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Parameter thru Form Dialog Box for REPORT | Sandy | Setting Up & Running Reports | 16 | January 10th, 2006 10:06 AM |
Reporting subreport total on main report | BobV | Setting Up & Running Reports | 22 | November 1st, 2005 03:19 AM |
To Sharkbyte and all: Calculate a total values in group level | Ally | General Discussion | 6 | June 13th, 2005 08:16 PM |
Help!! I'm running around in circles! | CathyA | New Users | 19 | December 12th, 2004 07:50 PM |
Save Report With CreateReport Coding Issue | Jeff Conrad | Setting Up & Running Reports | 8 | July 12th, 2004 08:39 AM |