Solved

Change format of form field control source

Posted on 2014-11-21
3
200 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

Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
How can you open the FORM2 2 32
Access sql to sql server express 10 36
Calculation in Access 5 26
Create macro from runcode 30 26
The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

832 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