Re: Report Margin

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: John Spencer (MVP) (spencer4_at_comcast.net)
Date: 08/15/04 

Date: Sun, 15 Aug 2004 14:17:31 -0400

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

Relevant Pages

  • Re: Right margin
    ... The right edge margin of the right header/footer is set at 3/4 inch. ... margins for header and body. ...
    (microsoft.public.excel)
  • Re: How can I have different top-bottom margins for pp.1&2 in same doc
    ... The way to do this is to set the top margin at 0.6", ... letterhead at the top of the first page. ... in the First Page Header. ... first page top margin and 1 inch for second page top margin - it seems to ...
    (microsoft.public.word.pagelayout)
  • Re: Header and Footer with RichTextBox Control
    ... I send the footer and header to RTB when it is prining but I ... Dim margin As Single, printControl As Boolean ... pageHigh = .ScaleY(.Height, vbTwips, vbInches) ...
    (microsoft.public.vb.general.discussion)
  • Re: Header and Footer with RichTextBox Control
    ... I send the footer and header to RTB when it is prining but I ... In that case the RTB will print its contents within that area of the page and you will know exactly what the minimum top and bottom margins of the printed pages will be. ... If the above is approximately what you are currently doing then all you need to do is print the header and the footer within the specified top and bottom margins, normally with the "nearest to the edge" vertical position of the header or footer text about half of the margin size from the edge of the page. ...
    (microsoft.public.vb.general.discussion)
  • Re: Margins & Headers
    ... See also the MVP FAQ: http://www.mvps.org/word which is awesome! ... > Space Before/After is all that is required (whether you have a letterhead ... > the header or just an empty paragraph). ... >>> top margin needs to be set at 2.25, ...
    (microsoft.public.word.docmanagement)