Ask Me Help Desk

Ask Me Help Desk (https://www.askmehelpdesk.com/forum.php)
-   Access (https://www.askmehelpdesk.com/forumdisplay.php?f=441)
-   -   Decimal Places (https://www.askmehelpdesk.com/showthread.php?t=512596)

  • Oct 1, 2010, 07:40 AM
    mcleyn
    Decimal Places
    Hi there,

    I have a form with a text book that is bound to a table. I would like to keep two decimal places when I enter a number inside the textbox. For example, $47.12
    I have set the properties for the table and the textbox to, format: currency and decimal places: 2.

    However, when I enter a number into the textbox, it always rounds and gives me zeros, instead of the actual number. For instance, if I enter $47.12, it automatically swithches to $47.00

    What seems to be the issue?
  • Oct 1, 2010, 03:10 PM
    ScottGem

    I'll bet the datatype is set to Integer. Change the datatype in the table to Currency.
  • Oct 8, 2010, 10:35 AM
    mcleyn
    Quote:

    Originally Posted by ScottGem View Post
    I'll bet the datatype is set to Integer. Change the datatype in the table to Currency.

    Thank you very much. That was the exact problem.

  • All times are GMT -7. The time now is 10:28 AM.