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

 

[Joseph Meehan]

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)

My guess is that this is a Word issue not Access. I suggest you start
by checking all the defaults and styles in the Word documents and templates
(templates are used even when all you see is the document, look at
normal.dot first. Also make sure they both have the same printer drivers
and all the default printer settings like margins are identical.

 

[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...