Consulting

Results 1 to 2 of 2

Thread: Text Boxes

  1. #1

    Text Boxes

    Hello,

    I've built a form in Microsoft Access that has several text boxes on it that I am using to enter numerical values, ie: 1.5, 2.25...

    Is there any coding that would add up the numbers that are entered in the text boxes and then display the total in another text box?

    Basically,

    I enter 1.0 in Text Box 1
    Text Box 1 - 1.0

    I enter 2.25 in Text Box 2
    Text Box 2 - 2.25

    Text Box 3 would automatically display to total of the numbers when added together.
    Text Box 3 - 3.25

    Any thoughts would be appreciated
    Thanks.

  2. #2
    VBAX Contributor
    Joined
    Oct 2012
    Location
    Brisbane, Queensland, Australia
    Posts
    163
    Location
    Put the following code in the Exit event for both TextBox Text1 and TextBox Text2

    [vba]Text3.Value = Text1.Value + Text2.Value[/vba]

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •