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.
 
Top