Formatting Currency Field Embedded in Text Box

[GliTTer]

Hello,

I'm trying to format a currency field that is embedded in a text box so that it has the $ and comma separator, but no decimal or trailing zeros. Currently, the expression looks like this:

="The company contributes " & Format([ContributionAmount],"Currency&quot & " per year for up to 10 years."

Which produces - $35,263.00

Only I want - $35,263

Changing it to "Standard" removes the $, but not the decimal.

Any advice is much appreciated.

Thanks!

 

[SgtJarrow]

Change your line to read....

="The company contributes " & Format([ContributionAmount],"$#,###&quot & " per year for up to 10 years."

Will produce the results you want. Programming isn't a profession of choice.
It's a profession of calling...
"Hey Programmer, your application broke again!"

Robert L. Johnson III, A+, Network+, MCP
Access Developer/Programmer

 

[GliTTer]

Thanks so much - that worked!!