We have an Access 2002 report with a memo field. The report looks good but when we convert it to Word 2002, the last few words at the end of most paragraphs are truncated. How can the word wrapping in Access 2002 be preserved in Word 2002?
You can either make the field in Word larger, or you can manually add in the chr(13) & chr(10) to the memo field, so the line lengths will be maintained. You may be able to export the data as text and have word use that as a trouble shooting measure, or link the word document to the query in the database then format it in word.
Thanks for yor reply but how can we make the Word field longer when we used (1) the Word Icon in Access which simply converted the report or
(2) the Office Tools, Publish in Word which did the same thing.
In the Access report design, we made the memo field larger but the report looked awkward wasting a lot of lines.
Your other suggestion was to manually add in chr(13) & chr(10) to the memo field, so the line lengths will be maintained. Where do we add these characters? At the Access report design? Kindly elaborate.
FYI, our database is Oracle 8i. Because we wanted a report in Word format, we used Access 2002 to access the Oracle database and make a report. This report was then converted to a Word document which unfortunately truncates the memo field about half of the time.