?
Solved

Page Set up is messing up from Access to Word using office links>Publish to word

Posted on 2012-03-23
2
Medium Priority
?
297 Views
Last Modified: 2012-03-27
I have my report all nice and formatted in Access. I have kept pretty tight margins to decrease the number of pages that prints in Word. I use the tool bar  Tools>Office Links> Publish to Word and the report publishes to word and the bottom margin changes from about .25 inches to 3.0 inches, adding tons of space at the bottom.

When I print directly out of Access, the margins are just fine. Trouble is I need to publish to Word, so I can post to our exchange server as a Word Document.

I did not know if there was a page set up command or preserve formatting field/property that I am missing?

Our work still uses Office 2003.

Thanks for any tips.
0
Comment
Question by:bvanscoy678
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 31

Accepted Solution

by:
Helen Feddema earned 2000 total points
ID: 37771901
RTF export generally doesn't work very well.  I recommend creating a properly formatted Word template, then using Automation code to fill a document created from the template with data from Access.  That gives you total control over the appearance of the Word document.  See my Code Sample #24 (Four Ways to Merge to Word) for more information.  It is rather old, but still works.  For more updated info (including Word 2007 and 2010), see my recent ebook, Working with Word.

Here is the link for the code sample:

http://www.helenfeddema.com/Files/code24.zip

For another example of exporting Access data to a Word document, see my Access Archon #44 (Merging to Word from Linked Access Tables):

http://www.helenfeddema.com/Files/accarch44.zip
0
 

Author Closing Comment

by:bvanscoy678
ID: 37772043
Thank you very much for the links. I just printed them and will read for the examples. I only have a couple of reports I deal with like this, so it is something I have just dealt with. But, it will be nice to possible fix them!

Thanks
0

Featured Post

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Outlook for dependable use in a very small business   This article is about using the Outlook application (part of Microsoft Office) in a very small business, or for homeowners where dependability and reliability are critical requirements. This …
Ever wonder what it's like to get hit by ransomware? "Tom" gives you all the dirty details first-hand – and conveys the hard lessons his company learned in the aftermath.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…

764 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question