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

jack drawbridge jackandpat.d at gmail.com
Tue Aug 14 09:15:44 CDT 2012


Thanks Lambert. You only have to do the replace with "" once to realize
there may be a different context. Replacing vbcrlf with space is easier
than changing  strHorriblyLongText back to  "space separated words".

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

> Good point Jack. :-)
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com [mailto:
> accessd-bounces at databaseadvisors.com] On Behalf Of jack drawbridge
> Sent: Tuesday, August 14, 2012 9:20 AM
> To: Access Developers discussion and problem solving
> Subject: 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
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>


More information about the AccessD mailing list