Access Report: Publish to Microsoft Word

[Mike Labosh]

We have a shared Access 2000 database that lives on an attached network
drive.

Two workstations have a strange discrepancy. They are both Windows 2000
Professional, and Office 2000 Professional. Both computers print to the
same network printer so it's not that goofy behavior where Access stores the
specific print driver with the report definition.

So from the database window, double click this report to run it and it comes
up in print-preview mode. Then hit the "Publish with MS Word" toolbar
button which generates a .doc file and opens it in word.

Here's the SAME record from the same page of the same report as generated
from these two different machines. Note the second sentence is chopped off
after the word "professional". I have compared the two different versions
of the generated word doc and they are identical, except the (bad) one has
lots of entries that are simply chopped off. Any guesses?

[Machine 1 (good)]

43446 Overall: 00
The service technician never called us back.
CSA: 08 (01, 10, 10, 09, 10, 08) (LEE MANCINI)
The person couldn't understand the actual directions of the pole, but
other than that they were professional and polite.
Field: - (DK, -, -, -, -) (Walsingham)

[Machine 2 (bad)]

43446 Overall: 00
The service technician never called us back.
CSA: 08 (01, 10, 10, 09, 10, 08) (LEE MANCINI)
The person couldn't understand the actual directions of the pole, but
other than that they were professional
Field: - (DK, -, -, -, -) (Walsingham)



--
Peace & happy computing,

Mike Labosh, MCSD

"When you kill a man, you're a murderer.
Kill many, and you're a conqueror.
Kill them all and you're a god." -- Dave Mustane

 

[Albert D.Kallal]

Usually this happens when test boxes, or controls are too close to each
other.

You need to OPEN UP the spacing between the margins, and also controls when
you send a report to a rft file (doc).

When I see problems like the above, usually the developer has expanded the
report to the ABSOLUTE LIMITS of the format. (so, in place of margins with 1
or .75 of a inch, they expanded things down to .5 or even less (don't even
go there!!!). Different default printer settings with reduce margins will
cause problems..

You need to be VERY liberal with your spacing of controls.

#1 - move each control a biter further apart (or, at least the one that is
cause problems)
#2 - keep things away from the margins...and make sure the page layout
margins are at least .75...., or the 1" default

Since users can, and often do mess with the layout features of word, you
have to give yourself a bit more elbow room.

And, since some printers are more restricted then others, then you need to
stay away from tight margins (less then .5). And, even when users share the
same printer on a network, they often change the default layouts, and thus
once again you need to stay away from "tight" layouts if you are to send
them to word...