Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 538
  • Last Modified:

How do upload and use a preprinted form with Access reports

I am trying to upload a preprinted form into an Access db so that my report prints on the appropriate form.  I uploaded the form but when I compare the printed version to the original the margins are off by 1/8 of an inch.  It appears the image size is a little smaller and was pushed a little to the right.  The report must be identical to the original in all aspects but filled in with the correct information.  What options do I have?
0
D_Mart
Asked:
D_Mart
  • 10
  • 10
  • 3
  • +1
1 Solution
 
D_MartAuthor Commented:
Hi - I see that I am listed as a trial member but I purchased an annual subscription
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
You'll have to modify the report to match the margins in your pre-printed form. If you open the report in Design view, you'll see quite a few settings. First one I try would be in the Page Setup section, where you can adjust the top, bottom, left and right margins. If that doesn't work, you'll have to move each individual control (textbox, for example) to coincide with your form.
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
BTW: Your status of Trial or Premium doesn't really make a difference in regard to your question. We'll answer them all regardless.
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
Rey Obrero (Capricorn1)Commented:
the easiest to adjust your report for the pre-printed form -
* create an  image of your pre-printed form
* use this image as an image of your report
   - now you can easily position the controls on the report, using the image as guide
0
 
GRayLCommented:
Just remember the left margin in the Page Setup take you to the left edge of the report design screen in which are your controls for Header, Detail and footer.  If you had 0.5" Left Page Margin, and a Left position of 0.4" for a text box and a Left Margin of 0.1" for text inside the text box, and the text was aligned left, then the contents would start to print at 0.5 + 0.4 + 0.1 = 1.0" from the left side of the paper.
0
 
GRayLCommented:
Of course the same logic applies when trying to determine where things start to print from the top of the sheet.
0
 
D_MartAuthor Commented:
The problem is that I have loaded the image into the db but when it prints and is compared to original image the left margin is off by 1/8 of an inch.  Everything is printing correctly in the specified areas but I can't seem to get the left side moved over any more even after shrinking the left marging in page setup.
0
 
D_MartAuthor Commented:
I am attaching the form from the db to show how it has been setup.
Database3.accdb
0
 
Rey Obrero (Capricorn1)Commented:
D_Mart
upload the image that you used
0
 
D_MartAuthor Commented:
Hi Capricorn - attached is the GIF image I am printing to and have tried to modify the GIF to no avail.  I am sure I have done something wrong along the way and am hoping you all can tell me what to do different/better.
dr0100f3.GIF
0
 
GRayLCommented:
My analysis shows that image to be 459 pixels wide by 595 pixels high - 6.375" X 8.26" @ 72 pixels/dots per inch.

You said:  "The problem is that I have loaded the image into the db..."  How are you incorporating that image into your form?  
0
 
D_MartAuthor Commented:
The report prints to the GIF file.  It appears the GIF file, when printed by itself, prints at the correct measurements but when the Access report prints to the image, it was shrinking the image or applying margins.  I modified the GIF image by cropping to account for the margin changes and that appears to have fixed the problem.  If you are aware of any other solution please let me know.  Thanks!
0
 
GRayLCommented:
How did you modify the GIF image?
0
 
GRayLCommented:
BTW you never did say how you are incorporating the GIF image into your report?
0
 
D_MartAuthor Commented:
Hi GRay,  I am a novice at Access and while researching possible solutions to print to a preprinted form I tried everything I stumbled accross and one was printing to the GIF and now I can't figure out how I am printing to the GIF.  I have looked at properties in design view and can't find a reference to how I attached this image to the report.  It has been very valuable and I really want to figure out how I did this for future reference.  I think I stumbled accross this solution on Experts-Exchange but my key word searches have not identified the solution again.  I hadn't realized that I was actually printing to an external file until I copied the db to another computer and it errored when it couldn't find the file.  

Your comment above helped me realize that I couldn't modify the margins in Access and pointed me to the image itself.  I opened the image in Microsoft Office Picture Manager and cropped the margins by a few pixols at a time until I received the desired results.  I did not know how to convert pixols to margin sizes so it took a while.

I am pretty sure I am linked to this GIF image and if you know how I could have possibly done that or know where I can look in my db to find that info I would greatly appreciate the information.  


0
 
GRayLCommented:
Have you made the GIF image the background of the the report?  Open the Report in Design view, right click, Properties, Format tab, what do you have set for picture?
0
 
D_MartAuthor Commented:
I don't see a picture setting in properties for the report.  I have attached a screen shot of the properties, format tab and the previously I attached the db that contains this report.  Let me know what you think.

Thanks,
D_Mart
CO-Sample.docx
0
 
Rey Obrero (Capricorn1)Commented:
from the drop down box in the Property window (where is says Detail), select Report and you will see the Picture property
0
 
D_MartAuthor Commented:
Capricorn - that is exactly what I needed.  I am attaching a screen shot of the Report properties.  Seeing some of the settings, whithout know what each of the settings may do, this could be where the problem lies with the report not maintaining the original size when printing.  Can you tell me if one of these settings may be the culprit and if so, which one(s)?
Report-property-view.docx
0
 
GRayLCommented:
Can you upload a copy of that GIF file?
0
 
D_MartAuthor Commented:
Hi GRay:  The file DR100f1.GIF is the original file and DR100f3.GIF is the one that I cropped.  The cropped one did not pass due to the margins not being equal to the original form.  Any help you can give towards printing on this image that will not change the original image positions will be greatly appreciated.
dr0100f1.GIF
0
 
D_MartAuthor Commented:
0
 
GRayLCommented:
I open a new report in design view.  Click File, Page Setup, set the page size to Letter and I make all margins 0.5" as this will surely accomodate all printers.  I ensure there are no group or page headers/footers. Click View and make sure they are unchecked.  With no headers/footers, the printed are is now 7.5" x 10.0" - the Detail area.  Make sure the Detail area is set to those dimensions.

Bring up the Properties for the Report.  Under the Format tab, set the Picture to the path and filename of dr01d00f3.gif, Picture Type - embedded, Picture Size Mode - Stretch. Width should be 7.5".

I placed a text box in the right side of the Service sales line of the GIF, set the Format of the text box to Currency, Decimal Places 0, and Font size 7.  In the Data tab, I set the Control source =120.

I clicked Report view, and saw $120 on the right side of the textbox in the correct position. I then printed the report and the print alignment was spot on.  Comments?
0
 
GRayLCommented:
I followed the same process with dr0100f1.gif and again it worked as expected. I think it is important not to make the margins the absolute minimum you printer can handle during page setup.  Again with this test I set them to 0.5" all around and with the detail sized at 7.5'' x 10" ( 8.5 x 11 Letter size with 0.5" margins) specifying Picture Size Mode - Stretch and Picture Alignment - Center.  Worked like a charm.
0
 
GRayLCommented:
Thanks, glad to help.
0

Featured Post

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

  • 10
  • 10
  • 3
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now