Still Problems removing Carriage returns (1 Viewer)

[KentAust]

I am wondering if anyone can help me.

I have a field in a table that contains carriage returns.

Is there anyway the carriage returns can be removed or replace with something leaving the remaining data in the field.

eg Committed P/O 931102 Issue
Supplier: 277

the above is all in one field there is a carriage return between
the Issue and Supplier as this is all one string.

I am not sure how to extract and delete the carriage return to leave just.

Committed P/O 931102 Issue Supplier: 277

 

[Alexandre]

In a query you could check for chr(13)
ex
SELECT MyTable.*
FROM MyTable
WHERE (((InStr(1,[MyMemoFieldName],Chr(13)))<>0));

In VBA for VBCrLf
ex
If InStr(1,YourSting, vbCrLf) <> 0 ...