Report fields incomplete when publsihed to Word

  • Thread starter Thread starter Jake
  • Start date Start date
J

Jake

I don't seem to have any problems with the formatting, but some memo fields
truncate text when publishing to Word from an Access report. I thought it
might just stop at 255 characters, like a text field, but it doesn't. It
can publish more than 255 characters, but it will leave off one word or
several words. It seems almost random. Has anyone seen this before and
have a solution?
Thanks,
Jake
 
Jake,

I am having the exact same problem (random text is not visible after export
to Word) which is why I'm searching the dbse. I don't see a reply to your
inquiry. Did you receive an answer? Please let me know if you do. Thank
you.
 
These questions were posted a long time ago but I'll reply in case it's still
an issue. Look for symbols in the data where it truncates. It's possible
the symbol is being interpreted as a marker that ends the data. I've seen
single quotes (apostrophes) do this on data going into tables in SQL Server
and DB2. In those cases it throws an error since the single quote ends up
messing up the SQL statement. If it turns out to be an apostrophe try adding
another one so it looks like a full quote mark ''. If it's an ampersand or
other symbol try enclosing it in apastrophes or full quotes. Doing this will
be a trial and error fix since the extra apostrophes and full quotes will
cause you problems saving the data.

The Replace() function will serve you well if this turns out to be a symbol
problem.
 
Back
Top