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

J

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???
 
M

Marshall Barton

JimR said:
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.
Click to expand...


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))
 
Top