enter number into table

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

hth


"reidapple" <reidapple.RemoveThis@discussions.microsoft.com> wrote in message
news:D8E10F32-2065-442A-97D3-0BDE96B48F55@microsoft.com...
> Hi,
>
> how do i enter number that starts with 0 into the table? like a phone
number
> for example?
>
> thx

On Sun, 17 Aug 2008 23:23:01 -0700, reidapple
<reidapple.RemoveThis@discussions.microsoft.com> wrote:

>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.
--

John W. Vinson [MVP]