Sign in
 
Home20132010Other VersionsLibraryForumsGallery
TechCenter >
> 
> 
Access 2010 Talbe Number Entry

Answered Access 2010 Talbe Number Entry

  • Sunday, February 26, 2012 12:26 PM
     
     
    Sign In to Vote
    0
    When I enter a real numbert (i.e. with decimal places) the number is rounded into an integer. Set the number of decimal places displayed to three (ex. 0.000). So 3.4 becomes 3.000, 3.6 becomes 4.000.
     

All Replies

  • Monday, February 27, 2012 2:15 PM
    Moderator
     
     Answered
    Sign In to Vote
    0
    Do as following:
    1. Choose the Data Type as “Number”.
    2. Set Format as “Standard”.
    3. Increase Decimals to  “3”. (Actually when we increase the Decimals, the Format will automatically set as “Standard”.)

    Max Meng
    TechNet Community Support

     
  • Thursday, March 01, 2012 3:31 AM
     
     
    Sign In to Vote
    0
    The number itself is rounded off, not just the display. As I say above: I enter 3.4, it turns into 3.000. Is there some number type I'm missing?
     
  • Thursday, March 01, 2012 3:38 AM
     
     
    Sign In to Vote
    0
    Found it: Deisng mode, Field Properties, select Field Size.