enter number into table

[reidapple]

Hi,

how do i enter number that starts with 0 into the table? like a phone number
for example?

thx

 

[tina]

if the Data Type of your field is Number, change it to Text.

hth

 

[Klatuu]

numeric data types do not carry leading zeros or any other formatting
information. You options are to use a text data type or use the Format
function when you present the number to a user.

 

[John W. Vinson]

Hi,

how do i enter number that starts with 0 into the table? like a phone number
for example?

thx

"Numbers" such as telephone numbers or Zip codes are not really numbers; you
won't ever be doing arithmatic operations with them, or incrementing them as
you might do with an invoice number. Use a Text datatype instead of any sort
of Number datatype for them.

Another reason to use text instead of number is that a Number field of the
default Long Integer datatype is limited to be no larger than 2147483647 - so
a phone number in any area code larger than 214 will not fit.