Update query with replace function fails

[Keven]

I created a memo field in a table and set it to be R T F .
i imported my data fields with all of the carriage return - line feeds changed to " ! " .
now I'm using an update query with a replace function to change all of the " ! " instances to c r l f.
the query uses chr(13)+chr(10) in the replace function.


when I run the query all of the " ! " are replace but there no visible effect on the text.
using c t r l - enter manually works to produce a carriage return-line feed, but why doesn't my replace function work??.
tried to same query in code using vbcrlf instead of the character codes and still couldn't replace correctly.
what's wrong??
keven

[davegri]

We really need to see your query syntax.

[CJ_London]

2007 uses html rather than rtf style (although still called rich text) - so you don't use chr(13)+chr(10)

Suggest, to confirm the code, you copy it and paste to notepad to see the actual formatting codes

take a look at this link which asks the same question

http://www.pcreview.co.uk/threads/ri...eturn.2842502/

[Keven]

Sounds like my problem... Exactly!
i'll try adding <br> to my replace function parameters!
i'll let u know if that works... Thanks for the tip
keven

[Keven]

was:
UPDATE tableabc SET tableabc.xxx = Replace([tableabc]![xxx]," ! ",Chr(13)+Chr(10));

this worked in replacing all of my space-bang-space's with carriage returns:
UPDATE tableabc SET tableabc.xxx = Replace([tableabc]![xxx]," ! ","<br>");

[RuralGuy]

If this thread is Solved, how about using the thread tools at the top of the thread to mark it Solved?