I have some data, stored in a memo field, that contains
Carrriage Returns.

I have to write this data into a different table, but need
to strip the CR/LF and replace it with a space.

Can anyone help me with how to do this?

Many thanks

Mark.

you can use replace() function:
strNew=replace(rst!MyMemo,vbcrlf," ")

then save strNew to different table
HTH
--
Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com


"Mark Haigh" <(E-Mail Removed)> wrote in message
news:797801c4843c$e779f450$(E-Mail Removed)...
>I have some data, stored in a memo field, that contains
> Carrriage Returns.
>
> I have to write this data into a different table, but need
> to strip the CR/LF and replace it with a space.
>
> Can anyone help me with how to do this?
>
> Many thanks
>
> Mark.

Use the Replace() function in the Append query that you use to populate the
other table.

Example of what you might enter in the Field column in query design:
Replace([MyMemoField], Chr(13) & Chr(10), " ")

Note that Access 97 and earlier has no Replace() function, and unpatched
versions of Access 2000 may have problems with it.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Mark Haigh" <(E-Mail Removed)> wrote in message
news:797801c4843c$e779f450$(E-Mail Removed)...
>I have some data, stored in a memo field, that contains
> Carrriage Returns.
>
> I have to write this data into a different table, but need
> to strip the CR/LF and replace it with a space.
>
> Can anyone help me with how to do this?
>
> Many thanks
>
> Mark.

Thanks Allen