• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 418
  • Last Modified:

Preserving line feed character in memo field in an Access Report

In an Access report I include a memo field from our ERP application that contains the line feed character so the memo field should appear like(In a Crystal Report this is how it appears):
                                      CHECK CONDITION OF DIE
                                       CODE 014.4
Instead the line feed characters are apparently ignored because the result is:
                     CHECK CONDITION OF DIECODE
Is this something that can be corrected ?

  • 2
1 Solution
Patrick MatthewsCommented:
Try replacing linefeed with carriage return + linefeed:

UPDATE SomeTable
SET MemoColumn = Replace(MemoColumn, Chr(10), Chr(13) & Chr(10))
CR can use Chr(10) on its own for a line feed.

Access requires chr(13) & chr(10).

I suspect the problem lies there and you would need to use a formula field to add the missing character.
Sorry not in CR now are we!!!

Use a Replace function in ACcess to replace one char with two.
StampITAuthor Commented:
I used the Replace function in the query that is the source for th report. Replaced Chr(10) with the Chr(13) Chr(10) sequence in the memo field. Worked. Thanks.
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.

Join & Write a Comment

Featured Post

Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now