Currency formating

[glenmac]

I have a form which shows sales tax for a price value. The calculation I've used are;
Me!GST.Value = CCur(Me!Pprice.Value) * 0.07
Me!PST.Value = CCur(Me!Pprice.Value) * 0.07
Me!Pprice.Value = CCur(Me!Pprice.Value) + (CCur(Me!GST.Value) + CCur(Me!PST.Value))
Frice = Me!Pprice.Value
I'd like to show the values formatted to look like currency, limiting the decimal places to 2. Is this possible? All help will be greatly appreciated.

 

[mpastore]

Have you tried format(). For example:

?format(100000.455,"$#,###.##&quot

yields

$100,000.46



Mike Pastore

Hats off to (Roy) Harper

 

[KarMac21]

The easiest way to do this is to choose "Currency" for the FORMAT property for your text box.

This will automatically convert the value in that field to currency.

 

[glenmac]

I'm embarassed thanks Karmac!