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  

Background picture for the whole page (incl. margins)



 
 
Thread Tools Display Modes
  #1  
Old December 24th, 2009, 10:20 PM posted to microsoft.public.access.reports
nahkhiir
external usenet poster
 
Posts: 1
Default Background picture for the whole page (incl. margins)

Dear experts,

I'm trying to create a report which is to be converted to a PDF-document.

The idea is that the document has a background picture of the size of an A4-
page, but the data should still be represented with margins.

If I set the picture-property of a report, I get the picture printed in the
print area and not on the whole page. If I make the margins smaller, I still
get a white border caused by the margins + the records are written to the
whole bottom of the first page if the report has two pages.

If I use an image control, then I need to reduce my margins again, so I get
the same problem with the data, and I also get extra blank pages, because
Access thinks that the size of the image is to big for a page, though I can't
see it.

I'm looking forward to your replies. All ideas are welcome!

  #2  
Old December 28th, 2009, 08:31 PM posted to microsoft.public.access.reports
Clifford Bass via AccessMonster.com
external usenet poster
 
Posts: 150
Default Background picture for the whole page (incl. margins)

Hi,

Choose a "printer" that allows for margins of 0 and set your margins to
0. Set your report width go the width of the paper. Increase the blank
space at the top of your report header and/or page header before any controls.
Likewise in the report footer expand it so there is an amount of blank space
after any controls. Move all of your controls to the right so that you
provide for a "margin" on the left. If you have both a report and a page
header, you will need to do some coding in the On Format event of the report
header section and/or page header section in order to prevent a large section
of blank space between the report header and the page header. What I might
do would be to include the page header stuff in the report header and make
the page header invisible on page 1 and visible on the remaining pages.

Hope that helps,

Clifford Bass

nahkhiir wrote:
Dear experts,

I'm trying to create a report which is to be converted to a PDF-document.

The idea is that the document has a background picture of the size of an A4-
page, but the data should still be represented with margins.

If I set the picture-property of a report, I get the picture printed in the
print area and not on the whole page. If I make the margins smaller, I still
get a white border caused by the margins + the records are written to the
whole bottom of the first page if the report has two pages.

If I use an image control, then I need to reduce my margins again, so I get
the same problem with the data, and I also get extra blank pages, because
Access thinks that the size of the image is to big for a page, though I can't
see it.

I'm looking forward to your replies. All ideas are welcome!


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ports/200912/1

 




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


All times are GMT +1. The time now is 11:06 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.