Using a MSWord document in an MSAccess report

Ray Ergenbright
Ray Ergenbright used Ask the Experts™
on
I want to use a Word document as a page in an Access Report. The Word page size is 8.5 X 11 with .25 margins on all 4 sides. The Access report page is set up exactly the same. The font on both document controls is Ariel 10.

The problem? When I copy the Word document over to the Access report page, the document expands to 10.5 inches wide and nothi8ng I do seems to work to get it to the 8" report width I need. I have attached two screen-shots to illustrate the issue.

Your assistance will be appreciated. I am reasonably proficient in both programs but I have exhausted my knowledge on this issue.
MSWord.PNG
MSAccess.PNG
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
President / Owner
Most Valuable Expert 2017
Most Valuable Expert 2012
Commented:
Try changing the size mode on the OLE object control to zoom rather than clip.   It looks like your word doc is zoomed when it's being inserted (not sure why).

 Outside of that, I would not use the word doc directly, but get it as an image and then use an image control for less overhead.

 You also may have issues with it being in the detail section, and may want to move it to the page header if your going to overlay any data on top of that.

 You can under lay the entire page, you just need top make sure you set the .MoveLayout property to false so you remain at the top of the page for the first detail record.

Jim.

Author

Commented:
Thanks Jim. What you offer sounds great. I will try it and if successful I will award you the solution. I really appreciate your suggestion and your quick response to my question.

Author

Commented:
Thank you for your valued solution!
Jim Dettman (EE MVE)President / Owner
Most Valuable Expert 2017
Most Valuable Expert 2012

Commented:
Quite welcome.

 Happy holidays!

Jim.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial