Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2004
    Location
    Claremont, CA
    Posts
    38

    Unanswered: Truncated memo field in Word 2002

    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?

    Thanks.

  2. #2
    Join Date
    Oct 2003
    Location
    Canada
    Posts
    574
    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.

  3. #3
    Join Date
    Jan 2004
    Location
    Claremont, CA
    Posts
    38

    Truncated memo field

    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.

    Thanks again.

  4. #4
    Join Date
    Apr 2004
    Location
    metro Detroit
    Posts
    634
    Create and format the report in a Word document that links to the Access database.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •