Avatar of howruaz9
howruaz9
Flag for Canada asked on

Phone # to number

Hi experts,

I have a phone# field formatting like (111) 123-4567, now I'm asked to provide number without area code and Hyphen, that means I should get 1234567. How do I get it?

Thank you very much in advance!
Microsoft Access

Avatar of undefined
Last Comment
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

8/22/2022 - Mon
SOLUTION
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER CERTIFIED SOLUTION
Rey Obrero (Capricorn1)

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
howruaz9

ASKER
Hi MX & cap,

Thank you very much to both of you, both solutions are working perfectly well.

All the best,
kaufmed

@DatabaseMX

That pattern looks so familiar  ; )
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

Yep ... thanks to you. And I had a comment crediting you. But I see what happened.  I have the code in two different places and grabbed the slightly older version ...
Your help has saved me hundreds of hours of internet surfing.
fblack61
kaufmed

Heheheh...   Can't beat code reuse!
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

:-)
howruaz9

ASKER
Thanks to you too, kaufmed. It's nice that the code is so popular and helping many people like me.
Couple of my old friends like MX (if you don't mind to be called old friend, MX) that have been paying attention to my questions for many years are always acting quick, I appreciate their effort.

Thanks all again!
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

no problem.  kaufmed must have a filter set for 'phone number', lol