simple format question

  • Thread starter Thread starter Mark Kubicki
  • Start date Start date
M

Mark Kubicki

i have the following entered as the format for a text box:
(000) 000-0000" x"000

but am getting a display that looks like this:
(000) 212-6757 x760

when it should be:
(212) 675-7760

The field has number data type and the last 3 digits (the phone number
extension) is not always included (I suspect that i may need to break the
extension out to a seperate field (?)

any thoughts would be greatly appreciated
-mark
 
Mark said:
i have the following entered as the format for a text box:
(000) 000-0000" x"000

but am getting a display that looks like this:
(000) 212-6757 x760

when it should be:
(212) 675-7760

The field has number data type and the last 3 digits (the phone number
extension) is not always included (I suspect that i may need to break the
extension out to a seperate field (?)
Click to expand...


First, numbers with extensions can too big to fit in a Long
number type field, so you need to do something.

Since you will never need to do any kind of arithmetic on a
phone number, it should be a Text type field. And, yes, the
extension should be in a separate Text field. If you should
ever want to select/sort/group by area code, then that
should also be in a separate Text field.
 
thanks...
-m.


Marshall Barton said:
First, numbers with extensions can too big to fit in a Long
number type field, so you need to do something.

Since you will never need to do any kind of arithmetic on a
phone number, it should be a Text type field. And, yes, the
extension should be in a separate Text field. If you should
ever want to select/sort/group by area code, then that
should also be in a separate Text field.
Click to expand...
 
I never use input masks, however you stated "field has number data type". I
wouldn't store phone numbers in a numeric field. Use a text field.
 
Back
Top