Phone Number FORMATTING

[czbacnik]

Hello! All I want to do is have my phone numbers appear [phone],
but
for some reason I keep getting all these weird -- in between the
numbers. I read that I should put "[phone]"! as an input mask,
but that didn't work. Does anyone have a suggestion?

I appreciate the help!
Thanks,
Carla

[Cyberwolf]

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.

[Mikal via AccessMonster.com]

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 [phone],
but
for some reason I keep getting all these weird -- in between the
numbers. I read that I should put "[phone]"! 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