Replace Carriage Returns with Spaces

[chitan]

I need help with what I thought would be a simple task.

I have a field (titled "description") with several lines that contain carriage returns/line breaks. I need to replace all of these carriage returns with spaces.

I have tried using the both codes "ALT+0010" and "Chr(13) & Chr(10)" in a Replace Expression:

Expr1: Replace([description], "Chr(13) & Chr(10)", " ")


Expr1: Replace([description], "(type ALT+0010 here)", " ")

But running the expression only opens up a new table, "Query1", showing what the results of the replacement are. It doesn't actually change the original table.

Can someone please help me with this? I can't believe how difficult it is!

Thank so much!

[pbaldy]

You want an update query:

UPDATE TableName
SET description = Replace(...)