-----------------------------------

BioHazardousWaste

Sun May 16, 2004 2:03 pm


Currency Formatting Problem....

-----------------------------------

Hey guys, i've been working with VB for a while now; nothing serious such as API, registry etc. but i've done quite a bit of other stuff. However, I keep running into the same problem, and it is really starting to piss me off.  When working with prices, I cannot get it to format correctly. 

E.X.
 I want to display $9.20 in the text box TxtFinalPrice...

First I do some calculations

    Pen $1.00
    Pencil $1.00
    Floppy Disk $4.00
    Ruler $2.00


blah blah, add em up u get $8.00, i'll assign that to Price
Price = 8

 Then we have to calculate tax (I live in Ontario - 15%)

 TotalPrice = Price * 1.15 and we get 9.2... so then I add a dollar sign
TotalPrice = "$" & TotalPrice

BUT

HOW THE HELL DO I GET IT TO ADD THE 0 TO THE END?

I've tried formatting the variable as currency, textbox as currency, rounding.. nothin works.. can somebody please give me a hand?


-----------------------------------

Brightguy

Mon May 17, 2004 4:13 pm


Re: Currency Formatting Problem....

-----------------------------------

txtFinalPrice.Text = Format(TotalPrice, "Currency")
or
txtFinalPrice.Text = FormatCurrency(TotalPrice)

TotalPrice should be a numeric variable.  There's no need to add a "$" sign if you format it like this.