Re: Using a picture (Form Template) as background in a report?
- From: Salad <oil@xxxxxxxxxxx>
- Date: Sat, 24 Sep 2005 20:42:22 GMT
MLH wrote:
Salad, try this...
Go to the http://www.ncdot.org/dmv/forms/licensetheft/download/LT260.pdf link. You'll see a PDF image of an NCDMV form. Print it out. Measure the area occupied by text. You'll see that the text occupies an area measuring close to 7" wide by 9" tall. Measure the LRTB margins closely. You'll see that they are .75" and the bottom is 1.25".
My PDF reader has an image select tool that works fine (Adobe PDF reader).
Select ONLY that 9x7 area. Everything outside your selection box should be clear white space. Rite clik inside your selection box and choose "copy". Open up MS Paint and paste it in there. Save it as a jpeg. Now, to Access. I'm using A97. Dunno what you are using. Would be nice if you could do it in A97 just for giggles.
Open a new report. Click File, Page Setup and set all margins to .75" except the bottom. Set it to 1.25" Get rid of the report header/footer. Size the Detail section to 7" wide and 9" high. Enter the file you saved for the report's Picture property setting. Picture Type: Embedded, Picture Size Mode: Stretch.
Does it appear to you that the top .25" or so of the image is cut off? I'm talking about in design mode. It does for me. When I print preview or actually print, all is visible. Its as if, in design mode, the picture shifted up about 1/4". If I place my fields on the image as I see it in design mode, when I print the report, they are all too high - and yes, they are about 1/4" too high. I think if I drop them all down about 1/4", the data will appear in the desired positions in the actual printout. It was a bear getting it all that close. This is not the most elegant solution, but it does offer consistency of printed output. You may have to adjust the position of a few controls in design view to 'massage' them into place. But once done, its done for good. In design view, the controls will appear out of place. But they'll fall exactly where you want them on your printouts.
Thanks. I will check out your suggestions. Yes, this all may be due to the margins of the printer, etc. It's funny that MS offers a picture, (back in Access 2.0 was out there was a story about using an IRS 1040 form as the input background on a form in Access Advisor) and not have the print match the field locations. Maybe they'll have "anchored" the pictures in the the new upcoming Access 12.
.
- Follow-Ups:
- References:
- Prev by Date: Re: Check on empty record set in VBA
- Next by Date: Re: Code for controling FTP from Access VBA
- Previous by thread: Re: Using a picture (Form Template) as background in a report?
- Next by thread: Re: Using a picture (Form Template) as background in a report?
- Index(es):
Relevant Pages
|