I have a textbox in which I want to display amount with $ symbol. I have written the formatting line. But instead of $ it is displaying ?
.txtField(priceAmt).Text = Format$(0, "currency")
If I have amount 55.00, it is getting displayed as ? 55.00. I want it to be displayed as $55.00.
This is happening in only my machine. When other person took the same code, it is giving expected result.
Two solutions : 1.As comment suggested by @Brian M Stafford, I changed line to Format$(0, "$0.00"). This worked for me. 2.In control panel settings, Currency was set to rupees symbol. I changed it into $ then it worked for me.

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With