Field property

[Guest]

Could anybody inform me about the field property that can contain a number
like this :

2-1124300632

Regards

 

[Guest]

To define a field that include a chr other then a number (like "-"), you need
to define the field as text.

Another option will be to store it as number but then use the format to to
change the display to include the dash

 

[John W. Vinson]

Could anybody inform me about the field property that can contain a number
like this :

2-1124300632

Regards

That's a Text field. It happens to contain mostly numeric characters, but it
appears to be a label or identifier.

One rule of thumb: if you won't ever be doing arithmatic operations with a
value, it probably should not be stored as a Number datatype. A telephone
number or zipcode or part number are all just Text.

John W. Vinson [MVP]