formatting decimal places

  • Thread starter Thread starter fishqqq
  • Start date Start date
F

fishqqq

I have a text field that i've set the control property as follows:

=Sum([QTY]) & " pcs - " & " " & [Lock HazStatus] & " at " & [Text10] &
" kgs Actual Wgt"

which returns

6 pcs - Haz at 544.307983398438 kgs Actual Wgt

Is there a way to format the [Text10] value to 2 decimal places?

thank you
Steve
 
I have a text field that i've set the control property as follows:

=Sum([QTY]) & " pcs - " & " " & [Lock HazStatus] & " at " & [Text10] &
" kgs Actual Wgt"

which returns

6 pcs - Haz at 544.307983398438 kgs Actual Wgt

Is there a way to format the [Text10] value to 2 decimal places?

thank you
Steve
Click to expand...

Sure: a couple. Probably simplest is

=Sum([QTY]) & " pcs - " & [Lock HazStatus] & " at " & Round([Text10],2) & "
kgs Actual Wgt"
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com
 
I have a text field that i've set the control property as follows:
Click to expand...
=Sum([QTY]) & " pcs - " & " " & [Lock HazStatus] & " at " & [Text10] &
" kgs Actual Wgt"
Click to expand...
which returns
Click to expand...
6 pcs -  Haz at 544.307983398438 kgs Actual Wgt
Click to expand...
Is there a way to format the [Text10] value to 2 decimal places?
Click to expand...
thank you
Steve
Click to expand...

Sure: a couple. Probably simplest is

=Sum([QTY]) & " pcs -  " & [Lock HazStatus] & " at " & Round([Text10],2) & "
kgs Actual Wgt"
--

             John W. Vinson [MVP]
 Microsoft's replacements for these newsgroups:
 http://social.msdn.microsoft.com/Forums/en-US/accessdev/
 http://social.answers.microsoft.com/Forums/en-US/addbuz/
 and see alsohttp://www.utteraccess.com
Click to expand...

thank you John
 
Back
Top