[MS_AccessPros] Re: How can I replace CRLF (with space) in thousands of Memo and Text fields in many tables in a database?

 

I've tried:

UPDATE [EXAM] SET [EXAM].[Memofield] = Replace([EXAM].[Memofield],'Chr(13) & Chr(10)','  ');

It says it worked except for 65 type conversion errors, but nothing seems changed and 12,000 fields seem to not have been changed.  Thanks - Mark

__._,_.___

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (2)

Visit Your Group

• New Members 1

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___