Guss Ginsburg
guss at beechnutconsulting.com
Tue Aug 14 08:07:09 CDT 2012
The Access constant vbCRLF contains that constant, which is Asc(13)). So, try something like this (disclaimer - I have not tested this): If instr(1, mytextfield, vbCRLF) >0 then ' if 0 then no CRLF, otherwise returns the position of the CRLF... Mytextfield = left(mytextfield, instr(1, mytextfield, vbCRLF) - 1) End If Sincerely yours, Guss Ginsburg Beechnut Consulting Services Phone: 504-252-9131 Cell: 713-553-6298 www.beechnutconsulting.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Garraway, Alun Sent: Tuesday, August 14, 2012 7: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