[AccessD] A2003:Remove Spaces from a string

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




More information about the AccessD mailing list