[AccessD] how do I remove CRL from text (field)?

Big, big thanks for the quick (and good) reply, saved my day! :D

-----Ursprüngliche Nachricht-----
Von: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] Im Auftrag von jack drawbridge
Gesendet: Dienstag, 14. August 2012 15:20
An: Access Developers discussion and problem solving
Betreff: Re: [AccessD] how do I remove CRL from text (field)?

If you are removing CrLf, you MAY want to repalce each with a single space.
Especially if you are removing CrLf from long text and wish to keep a long text of "words".
 Slight mod to Lambert's code
strVariable = Replace(strVariable,vbCrLf," ")

Just trying to guess the context--- I think we've all done this at some time or another.

jack

On Tue, Aug 14, 2012 at 9:01 AM, Heenan, Lambert < Lambert.Heenan at chartisinsurance.com> wrote:

> strVariable = Replace(strVariable,vbCrLf,"")
>
> That should do it.
>
> Lambert
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com [mailto:
> accessd-bounces at databaseadvisors.com] On Behalf Of Garraway, Alun
> Sent: Tuesday, August 14, 2012 8:34 AM
> To: Access Developers discussion and problem solving
> Subject: [AccessD] how do I remove CRL from text (field)?
>
> Hallo,
>
> who can I remove CRL (carriage return linefeed) from text (field)??
>
> Either with in built functions or VBA............
>
> Any tips would be really appreciated :-)
>
> alun
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com