Access 2000 find/replace carriage returns with space in contents of memo field

**Problem statement:** **Contents in an Access 2000 table (memo field) appears to be in paragraphs but actually each line has a carriage return at end of line.** **** **Requirements:** **Need the code/macro/queries etc. to find carriage returns and replace them with a space (so the contents in a table cell becomes a paragraph again)** **** **Must run in Access 2000 on Windows 2000.** ## Deliverables **Problem statement:** **Contents in an Access 2000 table (memo field) appears to be in paragraphs but actually each line has a carriage return at end of line.** **** **Requirements:** **Need the code/macro/queries etc. to find carriage returns and replace them with a space (so the contents in a table cell becomes a paragraph again)** **** **Must run in Access 2000 on Windows 2000.** **Please see attached **