Field property

P

Pietro

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

2-1124300632

Regards
 
O

Ofer Cohen

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
 
J

John W. Vinson

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

2-1124300632

Regards
Click to expand...

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]
 
Top