formatting a number field in a concatinated text string

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Access 2002 Report text bo

In the text sting below I want the number to be displayed in currency format with 2 decimal places. Where "cash Damt" is a calculated field set to currency format (which displays properly), when I call for thet field to be displayed in this line it shows up with no formatting, i.e., it drops the trailing zero.

=Trim("You may deduct $ " & [cash damt] & " if payment is postmarked by " & ([invoice date]+10) & "."

I have tried these ariations

=("You may deduct $ " & [cash damt] & " if payment is postmarked by " & ([invoice date]+10) & ".") $4.095 = 4.

=("You may deduct $ " & Round([cash damt],2) & " if payment is postmarked by " & ([invoice date]+10) & ".")$4.095 = 4.

=("You may deduct $ " & Round([cash damt],3) & " if payment is postmarked by " & ([invoice date]+10) & ".")$4.095 = 4.09

=("You may deduct $ " & CStr([cash damt]) & " if payment is postmarked by " & ([invoice date]+10) & "."

=("You may deduct $ " & Ccur([cash damt]) & " if payment is postmarked by " & ([invoice date]+10) & ".")
 
Try:
=Trim("You may deduct $ " & format([cash damt],"currency") & " if payment is
postmarked by " & ([invoice date]+10) & ".")

--
--Roger Carlson
www.rogersaccesslibrary.com
Reply to: Roger dot Carlson at Spectrum-Health dot Org


SamB said:
Access 2002 Report text box

In the text sting below I want the number to be displayed in currency
Click to expand...
format with 2 decimal places. Where "cash Damt" is a calculated field set
to currency format (which displays properly), when I call for thet field to
be displayed in this line it shows up with no formatting, i.e., it drops the
trailing zero.
=Trim("You may deduct $ " & [cash damt] & " if payment is postmarked by " & ([invoice date]+10) & ".")

I have tried these ariations:

=("You may deduct $ " & [cash damt] & " if payment is postmarked by " &
Click to expand...
([invoice date]+10) & ".") $4.095 = 4.1
=("You may deduct $ " & Round([cash damt],2) & " if payment is postmarked
Click to expand...
by " & ([invoice date]+10) & ".")$4.095 = 4.1
=("You may deduct $ " & Round([cash damt],3) & " if payment is postmarked
Click to expand...
by " & ([invoice date]+10) & ".")$4.095 = 4.095
=("You may deduct $ " & CStr([cash damt]) & " if payment is postmarked by " & ([invoice date]+10) & ".")

=("You may deduct $ " & Ccur([cash damt]) & " if payment is postmarked by
Click to expand...
" & ([invoice date]+10) & ".")
 
SamB said:
Access 2002 Report text box

In the text sting below I want the number to be displayed in currency format with 2 decimal places. Where "cash Damt" is a calculated field set to currency format (which displays properly), when I call for thet field to be displayed in this line it shows up with no formatting, i.e., it drops the trailing zero.

=Trim("You may deduct $ " & [cash damt] & " if payment is postmarked by " & ([invoice date]+10) & ".")
Click to expand...

=Trim("You may deduct $ " & Format([cash damt], "Currency")
& " if payment is postmarked by " & ([invoice date]+10) &
".")
 
Back
Top