Telephone Data Format?

E

Ed Dror

Hi there,

I have Access database with telephone column and
When I created a webform data grid
With VWD 2005 this column show
like this 5552223333
how do I format it like (555)222-3333

Thanks,
Ed Dror
 
B

blackstaronline.net

Dim strPhone as string = "5552223333"
Dim strNewPhone as String

strNewPhone = "(" & Mid(strPhone, 1, 3) & ")"
strNewPhone = strNewPhone & Mid(strPhone, 4, 3) & "-" & Mid(strPhone,
7, 4)

Hope it helps,
Jeremy Reid
http://blackstaronline.net/hgtit
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Members online

No members online now.

Forum statistics

Threads
473,744
Messages
2,569,483
Members
44,903
Latest member
orderPeak8CBDGummies

Latest Threads

Top