[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