By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,930 Members | 1,465 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,930 IT Pros & Developers. It's quick & easy.

Phone Number FORMATTING

P: n/a
Hello! All I want to do is have my phone numbers appear (555) 555-5555,
but
for some reason I keep getting all these weird -- in between the
numbers. I read that I should put "(999) 999-9999"! as an input mask,
but that didn't work. Does anyone have a suggestion?

I appreciate the help!
Thanks,
Carla

Apr 12 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
DId you use the built in format in Access. Open your table in design
mode click on the Phone # field and make it a text field and click on
the input mask option on the general tab. In there there is a Phone#
format.

Apr 12 '06 #2

P: n/a
sounds like you are inputting the parens and hyphens which you shouldn't do
with an input mask as it causes them to double up. You could put this code
in the afterupdate event of the text box you use for the phone number:

Me!MyPhoneNbr = Format(Me!MyPhoneNbr, "(###) ###-####")

Of course, that will save it in your table with the punctuation included.

HTH

Mike Pippins

cz******@gmail.com wrote:
Hello! All I want to do is have my phone numbers appear (555) 555-5555,
but
for some reason I keep getting all these weird -- in between the
numbers. I read that I should put "(999) 999-9999"! as an input mask,
but that didn't work. Does anyone have a suggestion?

I appreciate the help!

Thanks,

Carla


--
"We have met the enemy and he is us." -- Pogo Possum

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200604/1
Apr 12 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.