In Access memo field I need to replace hard returns with a space

[Guest]

I've been able to set up a query to display the field with all of the hard
returns but I don't know how to replace them permanently.
Thank you.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...-b526-a04790f2a587&dg=microsoft.public.access

 

[Rick B]

Why did you post this as a suggestion? That would indicate that you want
Microsoft to somehow address this in a future release of the application,
and you wish for people to vote on the validity of your request.

 

[fredg]

I've been able to set up a query to display the field with all of the hard
returns but I don't know how to replace them permanently.
Thank you.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...-b526-a04790f2a587&dg=microsoft.public.access

If your version of Access supports gthe Replace function you can use
it to replace all the returns right now.

Create an Update Query:

Update YourTable Set YourTable.[FieldName] =
Replace([FieldName],chr(13) & chr(10)," ");