Removing Carriage Returns from Text

[Birdy]

I have been able to do this before, but I have forgotten how.

We have a user that Constantly puts a CR at the beginning of the text in a memo field. Can this be stopped or even better, changed with a query before a report is run as it is causing serious problems with report printing???????

 

[FoFa]

Try the REPLACE function

 

[Birdy]

Replace ???????

Tried using a Replace function but want to do this in a Query not VBA.

Is there not a way of just removing it through a query?