Formatting output in a label

[chadp2002]

I'm programming a cash register system and want to output prices in the format "#.##" (eg. "€0.60&quot in a label. The prices are coming in from an access database and the "0's" are taken off, so it out puts like ".6" instead of "€0.60".

Can anyone help me?
Thanks.

 

[Hungoverhippie]

Label1 = Format(a$, "$0.#0&quot

if they are all under 1 this will work..

hope this helps!!
Hungoverhippie

 

[chadp2002]

thanks, should help with anything under 1 anyway.

 

[Jon4747]

Hi,
Label1.Caption = FormatCurrency(MyVar)

This will take into account your regional (currency) settings

Jon