Report background picture - alignment trouble

[RichO]

I designed a report that auto-fills fields in a tax form. For the background picture of the report I'm using a scanned image of the form which works fine.

The problem is that any text boxes I place on the report are out of alignment with the picture when I preview the report. The image below shows the report in design mode and then preview mode.

Any idea why the text boxes are not aligning properly?

Thanks

 

[boblarson]

Probably because you aren't taking into account the page margins. I think you may need to tweak it based on the print view and not what you see in design view.

 

[RichO]

Actually I did already toy around with the page margins and that didn't change the position of the text boxes.

I used stretch for the picture size mode property in order to fill the page because the image is larger than the report. When I reduced the size of the image (pixels) to 100 dpi and used "clip" mode, the alignment was off by even more. The problem seems to have something to do with the way Access is handling the image sizing.

 

[PC User]

I've been trying to do the same exact thing with my reports. I've tried various approaches.

Method 1: Import the MS Word form into Adobe Illustrator and then export it as in eps format. Then import the eps image into the reports background.

Method 2: Select and copy the the report on the MS Word document and past it into the report as an MS Word OLE object. Then measure the boundaries of the image on the hardcopy and use the hardcopy's dimensions to re-adjust the OLE image's dimensions. I make sure that the margins on the report are exactly the same as the margins as the MS Word document. Then I place my fields over the correct positions on the OLE object. As long as the measurements on the OLE object are the same as on the hardcopy, my fields are well aligned. When you use text or memo fields, have the "Can Grow" and "Can Shrink" properties set to No.

Depending on the MS Word document, I've some success in using both methods. Method 2 I found works best for me. However, I'm actively looking for a more reliable method.

~~ PC

 

[groengoen]

I've been trying to do the same exact thing with my reports. I've tried various approaches.


Depending on the MS Word document, I've some success in using both methods. Method 2 I found works best for me. However, I'm actively looking for a more reliable method.

~~ PC

Did you ever have any success with finding a more reliable method?

 

[gemma-the-husky]

its not anything to do the page header/footer is it?

access seems to set the margins, and the headers/footers, then the detail fills the remaining space

so perhaps that prinicple is causing your watermark to be offset