<div>
You are welcome ...<br />
<br />
mx
</div>


<div>
<div class="content wysiwyg-content">
I have an access form with 4 textboxes on it formatted as currency.<br />
<br />
textbox1<br />
textbox2<br />
textbox3<br />
textboxTOTAL<br />
<br />
The user will enter dollar values in the first 3 textboxes and I want the total displayed in textboxTOTAL. &nbsp;If the user makes a change to any of the values, &nbsp;I want the total to be recalculated. &nbsp;And how do I avoid confusing things such as when a total already exists in textboxTOTAL and the user makes a change to any of the texboxes that is not immediately reflected in textboxTOTAL.<br />
<br />
For example, let's say these are currently the textbox values:<br />
<br />
textbox1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;$1000<br />
textbox2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;$5000<br />
textbox3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;$4000<br />
textboxTOTAL &nbsp; &nbsp; &nbsp; &nbsp;$10000<br />
<br />
Now let's say a user deletes the data in textbox1. &nbsp; How do I avoid things like the following:<br />
<br />
textbox1 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<br />
textbox2 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;$5000<br />
textbox3 &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;$4000<br />
textboxTOTAL &nbsp; &nbsp; &nbsp; &nbsp;$10000 &nbsp; &nbsp;&lt;----value is still showing $10K even &nbsp;<br />
<br />
So I'm also looking for the proper way to handle recalculations. Thank you.
</div>
</div>


I have an access form with 4 textboxes on it formatted as currency.

textbox1
textbox2
textbox3
textboxTOTAL

The user will enter dollar values in the first 3 textboxes and I want the total displayed in textboxTOTAL.  If the user makes a change to any of the values,  I want the total to be recalculated.  And how do I avoid confusing things such as when a total already exists in textboxTOTAL and the user makes a change to any of the texboxes that is not immediately reflected in textboxTOTAL.

For example, let's say these are currently the textbox values:

textbox1                  $1000
textbox2                  $5000
textbox3                  $4000
textboxTOTAL        $10000

Now let's say a user deletes the data in textbox1.   How do I avoid things like the following:

textbox1                  
textbox2                  $5000
textbox3                  $4000
textboxTOTAL        $10000    <----value is still showing $10K even  

So I'm also looking for the proper way to handle recalculations. Thank you.

adding values in textboxes MS Access

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.