Issue with Word export from Access 2003

B

Bogdan

I'm coming with this old issue which is still occuring in Access 2003. Is
there any fix or workaround for it ? I really appreciate any advice. Thanks !

This topic has been posted before and my issue has the same behaviour.

-----------------
I have a report in access that is a fairly sophisticated merge of multiple
fields across multiple levels in my MS Access database (Access 2003).

When I export this report to MS Word (Word 2000) using 'Tools' - 'Office
links' - 'Publish it with MS Word' - some of the lines in the report are
truncated. The report is made up of primarily titles of presentations for a
conference. Titles of a certain length get truncated. Short ones are not
truncated (roughly 8/10 of a line or less) and long ones are not truncated
(going on to two lines) - only those that are approximately a full line long
have the final word or two cut off and those words do not appear at all in
the word document.

Details:

1. It never cuts off part of a word - only an entire word or words that
appear at the end of a line

2. This appears to happen regardless of the font, font size, or margins. I
have experimented with the margins extensively (although I am open to a
concrete response that might involve margins) and it did not help to have the
margins exactly the same on the report and the word document or larger on one
and smaller on the other (tried each variant).

EXAMPLES:

"Welcome, State of the Association, Presidential Strand Overview, and
Presidential Address"

is shortened to

"Welcome, State of the Association, Presidential Strand Overview, and
Presidential" - the "Address" that would fall at the end of the first line on
the MS Word page has disappeared (no it is not hiding in the margins, it is
gone!).

"Maintaining Independence: Balancing Client Needs with Professional
Standards of Evaluation Practice"

is shortened to

"Maintaining Independence: Balancing Client Needs with Professional
Standards of" - the "Evaluation Practice" has disappeared

CONTEXT AND CAVEATS:

Please note that it is not feasible for me to make this document directly in
Word - the level of sophistication needed for the merge, using multiple
levels, is not available in word - at least at my level of expertise (and I
need an answer that I can actually implement).

I know that I can address this by a painstaking review and hand-typing to
edit the word document. However, this is a process that I use regularly and
the word document that is produced, each time, is 150-200 pages. The time
needed to hand-edit is extremely long.
-----------------
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top