Results 1 to 2 of 2
  1. #1
    JRMoates is offline Novice
    Windows 7 64bit Access 2013 64bit
    Join Date
    Mar 2018
    Posts
    1

    How can I create a "QuickMath" entry method on a form

    I am brand new to the forum [just signed up today] so forgive me if my approach and use is flawed.
    That said, I have a form in a 2013 MS Access db that I would like to be able to allow the user to do on-the-fly calculations when entering.


    I used the phrase "QuickMath" because that's what QuickBooks allows in a given field within their forms.
    For example, when entering sales if there are 3 values [137.50 + 13.25 + 99], is there a way that allows the user to enter the sequence I show rather than have to run the calculation separately and input the sum of 249.75?
    Hopefully this makes sense, if not, please let me know.
    Thank you!

  2. #2
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    6,128
    Yes using the Eval function and two textboxes which I'll call Text1 and Text2
    In design view put this in Text2
    Code:
    =Eval([Text1])
    Change to form view and write your calculation in Text1. Do not include an equals sign
    The result is shown in Text2.

    Any valid calculation can be done with all standard mathematical operators and brackets as appropriate
    Colin Riddington, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I know I don't know, I keep quiet!

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

Similar Threads

  1. Replies: 17
    Last Post: 04-28-2017, 09:18 PM
  2. Replies: 4
    Last Post: 12-20-2015, 12:16 PM
  3. Replies: 1
    Last Post: 09-07-2015, 08:00 AM
  4. Replies: 9
    Last Post: 08-19-2013, 03:00 PM
  5. Replies: 4
    Last Post: 01-03-2013, 03:50 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