Results 1 to 2 of 2
  1. #1
    Danroved is offline Novice
    Windows 10 Access 2013 32bit
    Join Date
    Nov 2018
    Posts
    6

    Calculated fields

    I am multiplying two values: first field is a 2 decimal place standard format text box and the second field is 2 decimal place Currency format text field.
    I save the result in a 2 decimal place Currency format text field.


    When I click on the result value it changes to 4 decimal places. When I change focus from that text field it goes back to 2 decimal places.
    How do I change this so that the result only shows 2 decimal places?

  2. #2
    Minty is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    3,001
    Currency format is fixed at 4 decimal places. When you "edit" a value you will see the actual data not the formatted data.
    The same goes for a Date field with a time element. If you display it as short date you'll only see 1/11/2018 , but if you click in the actual data you'll see 1/11/2018 13:23:33

    If you only want 2 decimal places store the result as a decimal field fixed at 2 points.

    However, if you always have the multipliers available, you are storing redundant data, you should simply calculate the result any time you need it, and if any of the underlying values are changed you know your result will always be accurate.
    DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
    Please use the star below the post to say thanks if we have helped !
    ↓↓ It's down here ↓↓

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

Similar Threads

  1. Replies: 1
    Last Post: 04-12-2017, 07:39 AM
  2. Calculated Fields
    By kwettersten in forum Access
    Replies: 4
    Last Post: 08-04-2016, 07:58 AM
  3. Replies: 12
    Last Post: 10-01-2013, 12:59 PM
  4. Calculated fields
    By graciemora in forum Forms
    Replies: 1
    Last Post: 02-04-2011, 06:07 AM
  5. Sum of calculated fields
    By nkuebelbeck in forum Forms
    Replies: 9
    Last Post: 03-12-2010, 01:32 PM

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