removing CRLF from a memo field

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.
 
J

John Spencer (MVP)

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

Marshall Barton

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