Phone Number field

A

AJ Raiber

use the following in your input mask:

!\(999") "000\-0000;;_

Access also has a very nice assistant for these type
things. Press the button that has the "..." on it and use
the wizard there.

HTH

AJ
 
M

Mike Painter

AJ Raiber said:
use the following in your input mask:

!\(999") "000\-0000;;_

Access also has a very nice assistant for these type
things. Press the button that has the "..." on it and use
the wizard there.
Click to expand...

I hate input masks for a variety of reasons.
However since you already have the numbers
@@@ @@@-@@@@ in the format property will get what you want if the values
are text.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formatting Phone Numbers 0
Can't get input mask value to display on dataview page 2
phone number input mask with an optional extension 3
input mask for phone number 2
formatting a phone number in a string 2
Input Mask Default Value 3
Phone Number Formatting 8
need to search phone numbers 2

Top