Report Margin

[Irshad Alam]

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

 

[John Spencer (MVP)]

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.