How do you convert soft carriage returns inported from Excel to p.

[JimR]

I've imported data from an Excel spreasheet that includes soft carriage
returns. When I try to print a report of the data, the returns show up in
the Access report as "box" shaped characters - they do not force vertical
line spacing as is required.

Any ideas???

 

[Marshall Barton]

I've imported data from an Excel spreasheet that includes soft carriage
returns. When I try to print a report of the data, the returns show up in
the Access report as "box" shaped characters - they do not force vertical
line spacing as is required.

Excel uses Chr(10) for a "soft" new line, but Access uses
Chr(13) & Chr(10).

You can get rid of them by using an expression in the report
text box:

=Replace(thefield, Chr(10), "")

Or, you can translate them to the Access sequence by using:

=Replace(thefield, Chr(10), Chr(13) & Chr(10))