Carriage Returns

[Mark Haigh]

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.

 

[Alex Dybenko]

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

then save strNew to different table
HTH

 

[Allen Browne]

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.

 

[Mark Haigh]

Thanks Allen