Changing from text to currency and number error?

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Brian
    #1

    Changing from text to currency and number error?

    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
    Tags: None
    • KC-Mass
      #2
      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@gmai l.comwrote in message
      news:8956d2cf-c914-4545-93e4-6dfe9890f46e@f3 6g2000hsa.googl egroups.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

        Comment

        Previous template Next
        Working...