Format Currency

[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

 

[Dirk Goldgar]

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

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?

 

[Jeff]

Try this:

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

 

[Tim Ferguson]

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

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