<div>
Use the following in the Control Source Property for that textbox (include the = sign):<br />
<br />
= [size1] + [height1] + [weight1]<br />
<br />

</div>


Use the following in the Control Source Property for that textbox (include the = sign):

= [size1] + [height1] + [weight1]



<div>
Just a note on the above - That will display the total in the textbox, but not actually record it in the table.<br />
<br />
In general, derived (calculated) values like this should be calculated and displayed on an as-needed basis, not stored in the table. &nbsp;Storing in the table creates redundant data, and can complicate things if any of the parts of the calculation (such as height1) changes.
</div>


Just a note on the above - That will display the total in the textbox, but not actually record it in the table.

In general, derived (calculated) values like this should be calculated and displayed on an as-needed basis, not stored in the table.  Storing in the table creates redundant data, and can complicate things if any of the parts of the calculation (such as height1) changes.

<div>
question: is there anyway to have total calculated and also entered into table?<br />
I realize what you are saying about redundant data- but I am also trying to provide solution that is being asked for.<br />
but if not possible- let me know-<br />
thank you
</div>


question: is there anyway to have total calculated and also entered into table?
I realize what you are saying about redundant data- but I am also trying to provide solution that is being asked for.
but if not possible- let me know-
thank you

<div>
thinking this over- you may be right not to have entered in table- but i will leave last question stand - just for my own curiosity<br />
thank you
</div>


thinking this over- you may be right not to have entered in table- but i will leave last question stand - just for my own curiosity
thank you

<div>
Thanks for explanation and solution
</div>


<div>
<div class="content wysiwyg-content">
Hello,<br />
have attached sample db- when it opens a form comes up.<br />
I want the field [total] - to display the total of 3 other fields on the form-[size1],[height1],[we<wbr />ight1]<br />
<br />
thank you<br />
<a href="https://filedb.experts-exchange.com/incoming/2011/10_w45/518444/data123.accdb" target="_blank" class="file-inline" title="example (576 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>data123.accdb</a>
</div>
</div>


data123.accdb

Hello,
have attached sample db- when it opens a form comes up.
I want the field [total] - to display the total of 3 other fields on the form-[size1],[height1],[weight1]

thank you

display total of three fields in one field on form

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.