Format Currency

  • Thread starter Thread starter Jason
  • Start date Start date
J

Jason

I am using Access 97 with VBA. I am trying to format a
variable to show currency with commas. This what I am
using and it is not working:

Freight = Format(x, "#,###,#00.00")

Please Help
 
Jason said:
I am using Access 97 with VBA. I am trying to format a
variable to show currency with commas. This what I am
using and it is not working:

Freight = Format(x, "#,###,#00.00")

Please Help
Click to expand...

In what way isn't it working? What's the definition of Freight and of
x? Any special reason you aren't using the "currency" format string?
 
I am trying to format a
variable to show currency with commas. This what I am
using and it is not working:

Freight = Format(x, "#,###,#00.00")
Click to expand...

It helps if you give some indication of datatypes: Freight should be a
string and x should be a numeric. I notice that you have not put any
currency characters in this either;-

strFreight = Format(currX, "$#,#00.00")

or the equivalent (as Dirk suggests)

strFreight = Format(currX, "Currency")

B Wishes


Tim F
 
Back
Top