Currency in the middle of a sentence

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

Guest

There has got to be some way to make currency formating show up in a
sentence, either with a query or with coding in a text box.

"The total amount awarded for " & '[ProjectName]' & " was " & [TotalAwd] & "."

What am I doing wrong?

I can make two different boxes, but it's sloppy looking.

Thanks.
 
Use the Format function.... e.g.,

strV = "The amount is " & Format([TotalAwd],"Currency") & . . .

On the other hand, you may want to use specific formatting because currency
is going to show decimal places, as well as the currency unit... e.g.
$100,000.00 not $100,000.

Larry Linson
Microsoft Access MVP
 
Thank you so much. You guys are so tremendously helpful.

Larry Linson said:
Use the Format function.... e.g.,

strV = "The amount is " & Format([TotalAwd],"Currency") & . . .

On the other hand, you may want to use specific formatting because currency
is going to show decimal places, as well as the currency unit... e.g.
$100,000.00 not $100,000.

Larry Linson
Microsoft Access MVP

r. howell said:
There has got to be some way to make currency formating show up in a
sentence, either with a query or with coding in a text box.

"The total amount awarded for " & '[ProjectName]' & " was " & [TotalAwd] & "."

What am I doing wrong?

I can make two different boxes, but it's sloppy looking.

Thanks.
Click to expand...
Click to expand...
 
Back
Top