Change format of form field control source

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?
SteveL13Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Gustav BrockConnect With a Mentor CIOCommented:
That will be:

=[txtActualNeededPanelQty] & " Panels," & " Each " & Format([txtEachPanelWidthInInches], "0.000") & " Inches in Width, " & [txtHeightInFeet] & " Feet in Height"

/gustav
0
 
SteveL13Author Commented:
Nice.  Thanks.
0
 
Gustav BrockCIOCommented:
You are welcome!

/gustav
0
All Courses

From novice to tech pro — start learning today.