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???????
:confused: :confused: :confused:

Try the REPLACE function

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?