Darren DICK
d.dick at uws.edu.au
Fri Jan 14 20:36:28 CST 2005
Chris - exactly what I wanted Many thanks Darren -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Chris Mackin Sent: Thursday, 13 January 2005 4:05 PM To: Access Developers discussion and problem solving Subject: RE: [AccessD] A2003:Remove Spaces from a string Replace(YourString, " ", "") will do it. -Chris Mackin -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Darren DICK Sent: Wednesday, January 12, 2005 9:56 PM To: 'Access Developers discussion and problem solving' Subject: [AccessD] A2003:Remove Spaces from a string Hi Team Anyone got any code to remove spaces from a telephone number?? Eg I Want 02 1234 5678 to become 0212345678 Many thanks in advance Darren -- 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