Results 1 to 2 of 2
  1. #1
    trident is offline Competent Performer
    Windows 8 Access 2010 64bit
    Join Date
    Apr 2014
    Posts
    141

    Save numbers upto 2 decimal places in form and table

    I have a form where i enter amounts with decimal places.



    I need that decimal places reflects in the form and on the table.

    However, whenever I enter a number with decimals, it rounds off to the nearest ones. When I checked the table, the properties is Standard, decimal places is 2.

    How can i show it on the form and save this information on the table.

    Thank you for the assistance.

    Trident

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,822
    I never set those properties in table, only in textboxes on forms and reports.

    Sounds like you need to set the Field Size property to Double.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Formatting Numbers in Decimal Places
    By bigmatt911 in forum Queries
    Replies: 3
    Last Post: 12-20-2013, 12:46 PM
  2. Replies: 2
    Last Post: 08-27-2013, 07:39 PM
  3. Formatting for 3 decimal places
    By Triland in forum Forms
    Replies: 12
    Last Post: 01-24-2013, 10:49 AM
  4. Decimal Places
    By momodoujimnjie in forum Access
    Replies: 1
    Last Post: 01-09-2013, 04:49 AM
  5. Limiting decimal places
    By Cran29 in forum Access
    Replies: 13
    Last Post: 01-08-2011, 08:01 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums