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

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