Solved

Change format of form field control source

Posted on 2014-11-21
3
193 Views
Last Modified: 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?
0
Comment
Question by:SteveL13
  • 2
3 Comments
 
LVL 49

Accepted Solution

by:
Gustav Brock earned 500 total points
ID: 40457946
That will be:

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

/gustav
0
 

Author Comment

by:SteveL13
ID: 40458097
Nice.  Thanks.
0
 
LVL 49

Expert Comment

by:Gustav Brock
ID: 40458215
You are welcome!

/gustav
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

In Debugging – Part 1, you learned the basics of the debugging process. You learned how to avoid bugs, as well as how to utilize the Immediate window in the debugging process. This article takes things to the next level by showing you how you can us…
Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now