Carriage Returns

  • Thread starter Thread starter Mark Haigh
  • Start date Start date
M

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.
 
you can use replace() function:
strNew=replace(rst!MyMemo,vbcrlf," ")

then save strNew to different table
HTH
 
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.
 
Back
Top