removing CRLF from a memo field

  • Thread starter Thread starter rkp
  • Start date Start date
R

rkp

Any simple way to do this without parsing and using INSTR
chr(13/11) type searches? I have 5 or 6 memo items
separated by CRLF - I'd rather they were separated
by "XX" or " ", so they could be viewed on one line if I
want.
 
What version of Access?

You can use the VBA Replace function in Access 2000 and later. Access 2000
needs the latest service pack for this to work.
 
rkp said:
Any simple way to do this without parsing and using INSTR
chr(13/11) type searches? I have 5 or 6 memo items
separated by CRLF - I'd rather they were separated
by "XX" or " ", so they could be viewed on one line if I
want.
Click to expand...

You can use the Replace function for this:

Replace(field, Chr(13) & Chr(10), "XX")
 
Back
Top