Phone Number FORMATTING

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

czbacnik@gmail.com - 12 Apr 2006 17:30 GMT

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

Reply to this Message

Cyberwolf - 12 Apr 2006 20:31 GMT

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.

Reply to this Message

Mikal - 12 Apr 2006 22:08 GMT

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

>Hello! All I want to do is have my phone numbers appear (555) 555-5555,
>but
[quoted text clipped - 7 lines]
>
>Carla

Signature

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

Reply to this Message