I would like to find and replace a return character (or new line, or \n, or 
chr(10) -- take your pick) at the beginning of a field with an empty string 
"".

I would really rather not have to write an update query or a script. Is 
there a way to enter special characters into the find & replace dialogue box?

I would expect to be able to find "\n" and replace with "", matching "Start 
of Field" but that doesn't work.

I'm using Access 2003.

On Sun, 2 Dec 2007 17:50:00 -0800, mmapes
<mmapes@discussions.microsoft.com> wrote:

The F&R dialog can't do that. Write an Update query, using the Replace
function.

-Tom.


>I would like to find and replace a return character (or new line, or \n, or 
>chr(10) -- take your pick) at the beginning of a field with an empty string 
>"".
>
>I would really rather not have to write an update query or a script. Is 
>there a way to enter special characters into the find & replace dialogue box?
>
>I would expect to be able to find "\n" and replace with "", matching "Start 
>of Field" but that doesn't work.
>
>I'm using Access 2003.
>