Thanks Peter that is exactly what I was looking for.
--- In [email protected], "phoogenb" <[EMAIL PROTECTED]> wrote:
>
> In VBA (and Jet SQL through the expression service):
>
> Replace(StringVal, FindVal, ReplaceVal)
>
> OR
>
> Replace(MyData, Chr(13) & Chr(10), " ")
>
> Good luck,
>
> Peter Hoogenboom
>
> --- In [email protected], "Marty" <marty1118@> wrote:
> >
> > I have a small comments field that I would like to replace any
and
> all
> > Carriage-return Line-feed combinations with a "space". Is there
a
> > function in Access that converts someStringVal to
> someNewStringVal ?
> > This was a common fun in another database that I used but have
not
> been
> > able to find it in Access. If there is no such function, does
> anyone
> > here have a good work around for doing this?
> >
>
