How to have Phone # from Access appear as (###) ###-####

I have a "seek" from which is loading data from access files into VB Labels and it appears as ##########. I want it to be (###)###-####.
What code will do this?

Thanks!

Dave
dtmaurerAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Erick37Connect With a Mentor Commented:
Dim sNumber As String
sNumber = "2125551212"
Label1.Caption = Format(sNumber, "(###) ###-####")
0
 
dtmaurerAuthor Commented:
Thanks!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.