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" <ma*******@gmail.comwrote in message
news:89**********************************@f36g2000 hsa.googlegroups.com...
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