Replace new line character with space

[mc223]

I have data in ms access which has new line characters.I want to use the REPLACE function to replace all new lines in that particular column so that the data appears in a single line.What update query should I use?

[ADezii]

Assuming your Table Name is tblTest, and your Field is named [Field1]:

UPDATE tblTest SET tblTest.Field1 = Replace([Field1],Chr$(13) & Chr$(10)," ");

[mc223]

I actually tried the above query twice:once with chr(10) and next update query with chr(13) and it worked fine then

[NeoPa]

If the data were actually New Lines (vbCrLf or vbNewLine) then ADezii's code would work faultlessly. It's common for such data to contain other sequences though, especially if they are embedded within fields. In such an instance it is likely you'll need to replace either or both of Chr(13) and Chr(10). Glad you got it sorted anyway :)

Welcome to Bytes!