Change format of form field control source
Posted on 2014-11-21
I have this in the control source of a field on a form.
=[txtActualNeededPanelQty] & " Panels," & " Each " & [txtEachPanelWidthInInches] & " Inches in Width, " & [txtHeightInFeet] & " Feet in Height"
But the result, for example, is giving me:
9 Panels, Each 46.6666666666667 Inches in Width, 8 Feet in Height
I want the "46.6666666666667 " part of it to read "46.7" (three decimals rounded up) so the final result will be:
9 Panels, Each 46.667 Inches in Width, 8 Feet in Height
How do I change the control source to accomplish this?