formatting text boxes

[doug]

I have 3 text boxes on a form and a label that show the
sum of the 3. How do I format the text boxes and label so
it shows currency. If user enters 123 I want it to
display as $ 123.00 in the text box and in the label.
Thanks for your help

 

[papou]

Hi Doug
Use format:
TextBox1.Value = Format(CInt(TextBox1.Value), "# ##0 $")
HTH
Cordially
Pascal

 

[Doug]

Thanks, but there is still a glitch. When I enter a 2 I
get 2 $ and a "type mismatch" error message. I found
this "$#,##0.00_);[Red]($#,##0.00)" in the help menu,
but I can't get it to work either. Help!!

 

[Tom Ogilvy]

What event did you put it in? Should be AfterUpdate or Exit, but not
Change.

--
Regards,
Tom Ogilvy

Thanks, but there is still a glitch. When I enter a 2 I
get 2 $ and a "type mismatch" error message. I found
this "$#,##0.00_);[Red]($#,##0.00)" in the help menu,
but I can't get it to work either. Help!!