Change special characters

N

Ngan

I have a memo field where the user typed in data with line
breaks (or carriage return, not sure which) and stuff.
When I try to export the information, the export doesn't
do the records where the memo fields have these special
characters. How do I go about doing an find and replace
query to find the special character within the memo field
with a correct character so the record can be exported?

Ngan
 
A

Allen Browne

The Carriage Return/Line Feed is actually two characters in the memo field:
Chr(13) and Chr(10).

Create a query that replaces these characters with a space, and export the
query. Type something like this into the Field row of the query grid:
Replace([MyMemo], Chr(13) & Chr(10), " ")

Post back if you are using Access 97 or earlier, as the Replace() function
does not exist.
 
G

Guest

Thank you! This solved a different problem I was having.
This doesn't appear anywhere in the on-line help that I could find, so
thanks again!
Best,
John.


Allen Browne said:
The Carriage Return/Line Feed is actually two characters in the memo field:
Chr(13) and Chr(10).

Create a query that replaces these characters with a space, and export the
query. Type something like this into the Field row of the query grid:
Replace([MyMemo], Chr(13) & Chr(10), " ")

Post back if you are using Access 97 or earlier, as the Replace() function
does not exist.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Ngan said:
I have a memo field where the user typed in data with line
breaks (or carriage return, not sure which) and stuff.
When I try to export the information, the export doesn't
do the records where the memo fields have these special
characters. How do I go about doing an find and replace
query to find the special character within the memo field
with a correct character so the record can be exported?

Ngan
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top