How to make new line character active in an Access report?

D

Danney

Memo Daya type field contains a new line character. The character is
displayed when the report is produced and the first character of the new line
overprints on top of it. Like the action of a backspace. It does not go to a
new line.
Are there any tricks to solving this??
 
F

fredg

Memo Daya type field contains a new line character. The character is
displayed when the report is produced and the first character of the new line
overprints on top of it. Like the action of a backspace. It does not go to a
new line.
Are there any tricks to solving this??
Click to expand...

What is the "NewLine" character?
In Access, a new line requires both a carriage return character and a
new line character, chr(13) & chr(10), in that order.

Perhaps you imported the data from Excel for example, which uses just
chr(10).
If that is the case, run an update query on that field.

Update YourTable Set YourTable.[MemoName] =
Replace([MemoName],chr(10),chr(13) & chr(10));
 
Top