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
|
|||
|
|||
Report Margin
HOW TO SET THE MARGIN OF PAGE FOOTER (CONDITIONAL OR AS
PER REQUIREMENT ): SITUATION: The first page of the company-Letter-Head-Page is already a printed material page (already printed logo and name address etc. at header and bottom of the page) which covers about 3 inch of the page from top and 2 inch of the space at bottom. The second pages (continuition sheet/page) is also printed page but only a small logo at the side, so it needs only margin of 1 inch at top and 1 inch of margin at bottom of the page. SOLUTION I DID: I kept a space at Report Header accordingly so that it can start the printing after 3 inch on the first page. And on the next page is proceed accordingly, means its keeps the margin of 1 inch as I have set at page setup margin. Next I added some code on the page footer OnFormat Property. So that on the first page it will keep the margin of 2 inch from bottom and the second page margin will be only 1 inch at bottom. But the code does not work properly at first page and on the second page. The code is as follows : Private Sub PageFooterSection_Format(Cancel As Integer, FormatCount As Integer) If Me.Page = 1 Then Me.Section(4).Height = 2880 Else Me.Section(4).Height = 1440 End If End Sub THE ABOVE CODE DOES EFFECT PROPERLY ON THE FIRST PAGE AND SECOND PAGE OF THE REPORT . Please advise the solution to the above, so that I can set the margin of the first page and the continious pages as per my need. Regards |
#2
|
|||
|
|||
Page headers and footers are the SAME height throughout the report.
Perhaps, you can add a REPORT Header which will print only one time (on the first page). You can set its height to 2 inches, but not put any controls in it. Your first page will print A one inch Page Header A two inch Report Header and then begin printing your report details Subsequent pages will ony print the one inch page header. Irshad Alam wrote: HOW TO SET THE MARGIN OF PAGE FOOTER (CONDITIONAL OR AS PER REQUIREMENT ): SITUATION: The first page of the company-Letter-Head-Page is already a printed material page (already printed logo and name address etc. at header and bottom of the page) which covers about 3 inch of the page from top and 2 inch of the space at bottom. The second pages (continuition sheet/page) is also printed page but only a small logo at the side, so it needs only margin of 1 inch at top and 1 inch of margin at bottom of the page. SOLUTION I DID: I kept a space at Report Header accordingly so that it can start the printing after 3 inch on the first page. And on the next page is proceed accordingly, means its keeps the margin of 1 inch as I have set at page setup margin. Next I added some code on the page footer OnFormat Property. So that on the first page it will keep the margin of 2 inch from bottom and the second page margin will be only 1 inch at bottom. But the code does not work properly at first page and on the second page. The code is as follows : Private Sub PageFooterSection_Format(Cancel As Integer, FormatCount As Integer) If Me.Page = 1 Then Me.Section(4).Height = 2880 Else Me.Section(4).Height = 1440 End If End Sub THE ABOVE CODE DOES EFFECT PROPERLY ON THE FIRST PAGE AND SECOND PAGE OF THE REPORT . Please advise the solution to the above, so that I can set the margin of the first page and the continious pages as per my need. Regards |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
programmatically add controls to report | G | Setting Up & Running Reports | 2 | August 4th, 2004 09:11 PM |
Restrict Report To Current Record | Katherine R | Setting Up & Running Reports | 1 | July 15th, 2004 07:23 PM |
Restrict Report to Current Record | Katherine R | Setting Up & Running Reports | 1 | July 15th, 2004 07:23 PM |
Label | SRIT | General Discussion | 2 | June 22nd, 2004 09:42 PM |
need help make a report | [email protected] | General Discussion | 2 | June 16th, 2004 08:31 PM |