Phone Number FORMATTING

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

re: Phone Number FORMATTING

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.

re: Phone Number FORMATTING

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

czbacnik@gmail.com wrote:[color=blue]
>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[/color]

--
"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