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 >