We help IT Professionals succeed at work.

Leaving space at top of second page

Hi:
i have an official sheets with heading and footer to print my letter on it.
I need to pull down the printed records at the second page , so i can leave a space at top of page for the heading on the official sheets.
Please help.

1.PNG
3.PNG
-Report-Q2.mdb
Comment
Watch Question

M_SOLAIMAN,
Is all of the report printed on the same special paper? If so, you can adjust the Report's top and bottom margins to reflect the effective margins you want to use.
Or, you can use PageHeader and PageFooter sections to account for the space blocked by the special paper's design. It looks like you have a big space in the Report Header section, which will only affect page 1. remove that space and stretch the PageHeader and PageFooter to block printing on the special paper's ink.

HTH,
pT72
Now I see that you use PageHeader within the report. You can lengthen it by the (distance from page top edge to special paper text bottom) minus (Report's top margin), then move all controls from the top of the page header to the bottom of the page header.

I think it will help if you post the dimensions of the special paper to be more precise.

pT72
Mohammad Alsolaimanapplication programmer

Author

Commented:
Is all of the report printed on the same special paper? Yes
i well try your solutions soon
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Commented:
This is confusing as the solution here may effect the solution to your other related question.
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_27478731.html

Why not wait and get the answer to one question before posting another question...?
Mohammad Alsolaimanapplication programmer

Author

Commented:
You are right boag2000: I suppose to wait , sorry for harry
Your answer to the first question was good
Here I need the record in second page to start shifted to meddle of sheet
to leave a space for the formated papers.
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Commented:
Again, this is "If-y" because the number of records is set by the page itself.

AFAICT, this will not be easy, as the only way I know of to do this would be to adjust the margins.
Unfortunately doing this "Dynamically" will be tricky.

Why not dump the pre-printed papae stock and put the headings in your report, ...then this will all be easy AFAICT...

Let's see what the other Experts post, in case I am not understanding something here...


JeffCoachman
PageHeader.Height is now 0.698cm.  Increase this to 5.698cm (assuming 5cm of print on special paper). Move the labels within PageHeader from the top edge (top=0) to the bottom edge (top = 5cm).

Now, this will affect all pages by default, possibly messing up the design of page1 because that's where the Report Header goes. You can:

Easy) Redesign the Report Header to accommodate the new Page Header or:

Harder) Put the Page Header labels at the bottom of the Report Header and suppress the Page Header on Page 1. In the OnFormat Event of PageHeader:
Private Sub PageHeaderSection_Format(Cancel As Integer, FormatCount As Integer)
If FormatCount = 1 Then ' only make changes in the first format event
    If Page = 1 Then 'treat page 1 differently
        PageHeaderSection.Visible = False ' suppress page1 page header
    Else
        PageHeaderSection.Visible = True ' keep page header after page 1
    End If
End If
End Sub

Open in new window


pT72
Mohammad Alsolaimanapplication programmer

Author

Commented:
wonderful pteranodon72:
but how to show header on 1st page ?
i couldent understand the second part of your comments
please
1.PNG
2.PNG
Great! You just need to make a small change to the Report Header now.

Make the Report Header 0.698cm longer (original size of the Page Header).
Copy the 5 labels that are in the Page Header and paste them at the bottom of the Report Header section.

That way:
Page 1 shows Report Header including data labels -- and no Page Header.
Page 2+ shows Page Header with data labels.

Hope this helps,
pT72
Mohammad Alsolaimanapplication programmer

Author

Commented:
pteranodon72 , Yes , wonderful solution
thanks to all of you people in here