Access 2000 find/replace carriage returns with space in contents of memo field
$30-5000 USD
已关闭
已发布将近 16 年前
$30-5000 USD
货到付款
**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
**