faqts : Computers : Databases : Microsoft Access

+ Search
Add Entry AlertManage Folder Edit Entry Add page to http://del.icio.us/
Did You Find This Entry Useful?

15 of 51 people (29%) answered Yes
Recently 4 of 10 people (40%) answered Yes

Entry

1. My database has some memo fields which contain carriage returns. How can I remove them?

May 8th, 2002 23:35
Ka Chun Tom Chiu, Sean Carroll,


I believe you can just run a query to do so.  Or else, you can do a 
simple VB program.  Just get the string from Memo and then use 
the "Replace" function (available since VB6) to replace all vbNewline 
into vbNullString, and that is it.  If it is not CR + LF but just CR, 
then use vbCR instead.