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/comm....public.access

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.


--
Rick B



"Musensohn" <(E-Mail Removed)> wrote in message
news:103E1893-6C91-4F35-B526-(E-Mail Removed)...
> 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/comm....public.access

On Tue, 21 Feb 2006 06:36:27 -0800, Musensohn wrote:

> 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/comm....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)," ");

--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail