Print first page of report on letter head

S

SF

Hi,

I have a contract report working nicely until yesterday then management
decide to use the pre-print letter head on the first page of the contract.
The contract suppose to be printed of both side as our printer has a duplex
for this porpose. I have remove the top organization logos, (sound easy
enough) so that I report will not print on the org. logo from the
pre-printed letter.

My problem that I face is that there is a contact address at the footer of
the pre-printed letter, so I have to leave at least 1.5" at the bottum of
the first page. I think of using page break but this would affect the other
pages as well, I would also don't want to put the page numbering on the
first as well.

I hope this group would suggest something
 
F

fredg

Hi,

I have a contract report working nicely until yesterday then management
decide to use the pre-print letter head on the first page of the contract.
The contract suppose to be printed of both side as our printer has a duplex
for this porpose. I have remove the top organization logos, (sound easy
enough) so that I report will not print on the org. logo from the
pre-printed letter.

My problem that I face is that there is a contact address at the footer of
the pre-printed letter, so I have to leave at least 1.5" at the bottum of
the first page. I think of using page break but this would affect the other
pages as well, I would also don't want to put the page numbering on the
first as well.

I hope this group would suggest something

So if I understand you, you wish to have a page break about 1.5 inches
up from the Page Footer just on the first page as well as not print
the page number on the first page.

Add a page break to the detail section near the bottom.
Code the Detail Section's Format event:
Me![PageBreakName].Visible = (Me.Page = 1 and Me.Top >= 4 * 1440)

You'll need to change the 4 * 1440 to whatever value works for your
layout. The 4 represents inches and 1440 the number of Twips per inch.
Access measurements are in Twips.

To hide the page number on the first page, either:
1) Code the Format event of whatever section you placed the page
number control:
Me![Name of the Page Number Control].Visible = Me.Page > 1
or...
2) You can use the Insert Menu + Page Number and uncheck the 'Show
Number on First Page' check box.
 
S

SF

It work!.
Thank you.
SF
fredg said:
Hi,

I have a contract report working nicely until yesterday then management
decide to use the pre-print letter head on the first page of the
contract.
The contract suppose to be printed of both side as our printer has a
duplex
for this porpose. I have remove the top organization logos, (sound easy
enough) so that I report will not print on the org. logo from the
pre-printed letter.

My problem that I face is that there is a contact address at the footer
of
the pre-printed letter, so I have to leave at least 1.5" at the bottum of
the first page. I think of using page break but this would affect the
other
pages as well, I would also don't want to put the page numbering on the
first as well.

I hope this group would suggest something

So if I understand you, you wish to have a page break about 1.5 inches
up from the Page Footer just on the first page as well as not print
the page number on the first page.

Add a page break to the detail section near the bottom.
Code the Detail Section's Format event:
Me![PageBreakName].Visible = (Me.Page = 1 and Me.Top >= 4 * 1440)

You'll need to change the 4 * 1440 to whatever value works for your
layout. The 4 represents inches and 1440 the number of Twips per inch.
Access measurements are in Twips.

To hide the page number on the first page, either:
1) Code the Format event of whatever section you placed the page
number control:
Me![Name of the Page Number Control].Visible = Me.Page > 1
or...
2) You can use the Insert Menu + Page Number and uncheck the 'Show
Number on First Page' check box.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top