Phone Number field

  • Thread starter Thread starter AJ Raiber
  • Start date Start date
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
 
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.
 
Back
Top