Word document exported from Access

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

S. Kissing - 28 Apr 2005 16:12 GMT

When I export the report from Access to Word I get a page break inserted and
multiple blank lines at the end of the page. If I delete the page break my
heading moves up...Any ideas on why the formatting adds the page break and
how I can fix it. This is an 80 page report so I can not format each page.
Thanks

Reply to this Message

Cindy M -WordMVP- - 30 Apr 2005 14:21 GMT

Hi =?Utf-8?B?Uy4gS2lzc2luZw==?=,

> When I export the report from Access to Word I get a page break inserted and
> multiple blank lines at the end of the page. If I delete the page break my
> heading moves up...Any ideas on why the formatting adds the page break and
> how I can fix it. This is an 80 page report so I can not format each page.

The Access command converts the report to RTF format, and puts everything in as
static text (headers/footers, for example). Then it has Word open the RTF file.
When Word does that, it's not said that the way it interprets the fonts and
margins will exactly match how Access laid out the page, so the page and line
breaks, and other things, may well shift. There's nothing you can do to change
this, except that you could TRY changing the margin settings in the document so
that Word interprets the layout the same way as Access.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 8 2004)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply
in the newsgroup and not by e-mail :-)

Reply to this Message

Rate this thread: