telephone format

  • Thread starter Thread starter Esperanza
  • Start date Start date
E

Esperanza

Hello VBA expert !,

I would like to see the format of telephone number like : 111-1111
the source is numeric like 1111111.

I tried to change the inputMask or the format of my text box but nothing
works.

Thanks in advance !!

Esperanza
 
Hello VBA expert !,

I would like to see the format of telephone number like : 111-1111
the source is numeric like 1111111.

I tried to change the inputMask or the format of my text box but nothing
works.
Click to expand...

I would VERY strongly suggest using a Text datatype rather than Number
for telephone numbers. You'll never be doing arithmatic with phone
numbers; they are really an identifier, not a numeric value.

However, with either text or numeric datatype, you should be able to
use a Input Mask property of

000\-0000;;_

or, if you want to include area codes,

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

should work.
 
Back
Top