Embed Carriage Returns

  • Thread starter Thread starter brinyblue
  • Start date Start date
B

brinyblue

Thanks in advance.
I have a text field stored in MySQL with line
breaks/returns delimited as ||. I need to bring these into
an Access report and display the text with the || replaced
with breaks/returns that the report will honor. I cannot
use the Replace function. I have tried replacing the ||
with vbCRLF and with Chr(13) & Chr(10) using REPLACE in
the query These values end up represented the the
displayed field as and those strings and not as control
characters. What am I missing.

Thanks again,
 
brinyblue said:
Thanks in advance.
I have a text field stored in MySQL with line
breaks/returns delimited as ||. I need to bring these into
an Access report and display the text with the || replaced
with breaks/returns that the report will honor. I cannot
use the Replace function. I have tried replacing the ||
with vbCRLF and with Chr(13) & Chr(10) using REPLACE in
the query These values end up represented the the
displayed field as and those strings and not as control
characters. What am I missing.
Click to expand...


Your db engine does not know about Access functions. Try
using Replace in the report text box's control source
expression:

=Replace(thefield, "||", Chr(13) & Chr(10))
 
Back
Top