removing CRLF from a memo field

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

 

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

 

[Marshall Barton]

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.

You can use the Replace function for this:

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