some data is not visable in a report published in word

  • Thread starter Thread starter Charlie
  • Start date Start date
C

Charlie

I have a database of test questions which generates tests
based upon certain criteria.

After generating a test, I use a report to display the
test for printing. All data displays when viewing the
report in Access. However when I try to publish the test
to Word or Excel (to make subtle changes or to modify
layout) not all the data is transfered to Word or Excel.

It is always the same field which does not display. Does
anyone have a suggestion as to what might cause this?
 
Allen,

Thanks for the lead, but this does not appear to be the
problem as my questions are not in a memo field.

Additionally, the data field is not truncated, it is not
there at all.
 
Hmm. What else might be at work here?

This field is not in a subreport?

Is there anything else odd about the formatting of this field?
E.g. is the ForeColor something other than zero (which may fail with some
printers)?

Is it the right-most field on the report (so it may be on subsequent pages)?
You say previews correctly, the margins may come into the export.

If it cannot be solved that way, would it be possible to use TransferText to
output the query that the report is based on, instead of outputting the
report?
 
to Allen & Charlie -
I am also having this problem. Some data fields do not show up at all, and others are repeated in the Word document. I tried the export to Text feature, but the formatting is not workable for my purposes. Any more ideas?
Christin

----- Allen Browne wrote: ----

Hmm. What else might be at work here

This field is not in a subreport

Is there anything else odd about the formatting of this field
E.g. is the ForeColor something other than zero (which may fail with som
printers)

Is it the right-most field on the report (so it may be on subsequent pages)
You say previews correctly, the margins may come into the export

If it cannot be solved that way, would it be possible to use TransferText t
output the query that the report is based on, instead of outputting th
report

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.htm
Reply to group, rather than allenbrowne at mvps dot org

Charlie said:
Thanks for the lead, but this does not appear to be th
Click to expand...
problem as my questions are not in a memo field
Click to expand...
 
Back
Top