A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Report Margin



 
 
Thread Tools Display Modes
  #1  
Old August 15th, 2004, 03:21 PM
Irshad Alam
external usenet poster
 
Posts: n/a
Default 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  
Old August 15th, 2004, 07:17 PM
John Spencer (MVP)
external usenet poster
 
Posts: n/a
Default

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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

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


All times are GMT +1. The time now is 06:44 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.