Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004

    Unanswered: Access Removing Decimal Places

    I've got a field in the DB to capture CPU speed. The guy who created it initally set it up as a Text field, we had issues sorting so we bumped it over to Numeric. The problem now is that if I have a 1.8Ghz machine I need to enter and I type in "1.8", it automatically rounds the number up to "2".
    An ideal solution would be that only decimals showup with a decimal point (so 266mhz won't become 266.00 mhz for example).

    Any suggestions?

  2. #2
    Join Date
    Dec 2003

    change the DataType

    Change the datatype from an integer to a Double. Should be able to be reset in the controls for the text box.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts