Solved

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

Posted on 2012-03-23
2
295 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 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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

Access custom database properties are useful for storing miscellaneous bits of information in a format that persists through database closing and reopening.  This article shows how to create and use them.
This article describes how to import an Outlook PST file to Office 365 using a third party product to avoid Microsoft's Azure command line tool, saving you time.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

739 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