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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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