Find and replace new line character

[mmapes]

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.

 

[Tom van Stiphout]

On Sun, 2 Dec 2007 17:50:00 -0800, mmapes

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

-Tom.