Labels and currency


Posted by Duane Kennerson on July 08, 2001 10:51 AM

I'm trying to have a label on a form display the contents
of a cell. The contents of the cell is in currency format
but when it is displayed in the label, I do not have the
currency format anymore.
Ex. The cell says $3,000.00. The label will display it as
3000. Im placing the cells contents into the labels caption
property. Is this incorrect? Is there another property I
should be using? Any solutions?
Thanks.



Posted by Ivan F Moala on July 08, 2001 11:46 AM

Duane
something like this or similar;

Label1.Caption = Format(Range("A1"), "$ ####.00")

Ivan