Replace Carriage returns in a text field?

  • Thread starter Thread starter Patrick
  • Start date Start date
P

Patrick

In a report,I wish to replace carriage returns in a text
field with commas. Does anyone know how to do this?
Thanks,
 
Patrick said:
In a report,I wish to replace carriage returns in a text
field with commas. Does anyone know how to do this?
Click to expand...

If you have A2K or later, then the Replace function can
easily do this. You don't say where/how the field is being
used, but in a text box you might try:

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

Note: Make sure the text box has a different name than
thefield.
 
Back
Top