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
Solved

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

Posted on 2012-03-23
2
292 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
2 Comments
 
LVL 31

Accepted Solution

by:
Helen_Feddema earned 500 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

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
It’s the first day of March, the weather is starting to warm up and the excitement of the upcoming St. Patrick’s Day holiday can be felt throughout the world.
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial well show you how to find and replace special characters in Microsoft Word. This is similar to carriage returns to convert columns of values from Microsoft Excel into comma separated lists.

861 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