Re: Changing from text to currency and number error?

Hi Brian

Check the field length of the original character field.  You probably are 
not storing long
strings of numbers but access doesn't know that.  If there is a lot of
data 
and you are concerned
about losing any data, create a new field as currency and fill it from the

old field with
a query.  When you are satisfied that the data went over correctly you can

delete the old field.

As to converting the zipcode field to a number - Don't!  Many zipcodes are

zero led like "02172".
If you make that a numeric field the leading zero will disappear.  Besides

you do not do math with zipcodes
so why make it numeric.

Regards

Kevin

"Brian" <magiklair@[EMAIL PROTECTED]
> wrote in message 
news:8956d2cf-c914-4545-93e4-6dfe9890f46e@[EMAIL PROTECTED]
> Hello,
> I am new to Microsoft access 2007 and I have created a new database.
> There is a dollar about that I have to change from text to currency
> format.
> Also, there is a zip code that I have to change from text to number
> format.
> When I try to change them from text to either currency or number
> format I get an error stating "Some data may be lost" The setting for
> the FieldSize property of one or more fields have been changed to a
> shorter size.  If the data is lost, validation rules may be violated
> as a result.  Do you want to continue anyway?  Any feedback would be
> greatly appreciated.
> Thanks,
> Brian