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