Find and replace new line character

M

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.
 
T

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Replace Carriage Return ASCII Character in Memo Field 3
DoCmd Find and Replace 5
Find and Replace special characters 6
Some sort of "Find and replace" 4
Find/Replace Macro 3
Carriage return & Line feeds 4
What is the box character in a text field and how do I replace it? 2
Find and Replace field name 1

Top