simple format question

[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

 

[Marshall Barton]

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 (?)

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.

 

[Mark Kubicki]

thanks...
-m.

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.

 

[Duane Hookom]

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.