formatting a number field in a concatinated text string

[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) & ".")

 

[Roger Carlson]

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

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) & ".")

I have tried these ariations:

=("You may deduct $ " & [cash damt] & " if payment is postmarked by " &

([invoice date]+10) & ".") $4.095 = 4.1

=("You may deduct $ " & Round([cash damt],2) & " if payment is postmarked

by " & ([invoice date]+10) & ".")$4.095 = 4.1

=("You may deduct $ " & Round([cash damt],3) & " if payment is postmarked

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

" & ([invoice date]+10) & ".")

 

[Marshall Barton]

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) & ".")

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