When exporting an Access report to Word

When exporting an Access report to Word in that words within the report are dropped (always in the same area) What causes this?
LVL 5
fbcbloodcenterAsked:
Who is Participating?
 
Jeffrey CoachmanMIS LiasonCommented:
Exporting Access Reports to Word (rtf) was never, ... and never will be, ...Perfect.
(is this same data cut off when viewed in the Access Report?)

What version of Access are you using?
In Access 2003 help files, there were several tips on formatting the Access report to make the export "Better".

<it is actually words from 2 different labels with in detail section;
the word “Discrepancies” and the word “Action:” ">
If you mean the *words* "Action" and  "Discrepancies" are cut off, then make the label longer...
In your screenshot, it appears that the "Discrepancies" label/textbox may have ended up running "Behind" another textbox/Label.
(This is the inherent issue with "Butting" controls up against each other, or overlapping them)

Or are you confusing Labels with Textboxes...?

If this label text is being dynamically generated, then you may have to dynamically increase the length of the label, or simply use a textbox instead.

In any event, the (design View) screenshot you posted does not really display this issue.
Can you post a screenshot (in Print Preview) where this works (displays as you want) and when it does not (cuts off the text)?

In a nutshell, it is difficult to determine what this issue actually looks like.
Once we see this, I am sure any expert here can figure out what needs to be done.

;-)

JeffCoachman
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
What "area" of the report is this? Is it a Subreport, for example, or a calculated value?

In general, exporting Access reports tends to drop much of the formatting.
0
 
fbcbloodcenterAuthor Commented:
the words that are dropping when exporting are not part of a sub report, apparently the 2 sub reports are exporting with no issue it is actually words from 2 different labels with in detail section;
the word “Discrepancies” and the word “Action:”

Access.png
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Best advice I could give is to remove and re-insert the labels, and to try changing the Font used with the label (also change the size and such). Not sure this will work, but it might be helpful.
0
 
Jeffrey CoachmanMIS LiasonCommented:
Can you state what the ultimate fix was, as I make several suggestions above.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.