formatting text boxes
 

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

formatting text boxes
 

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

"doug" a écrit dans le message de news:
...
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

formatting text boxes
 

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!!
-----Original Message-----
Hi Doug
Use format:
TextBox1.Value = Format(CInt(TextBox1.Value), "# ##0 $")
HTH
Cordially
Pascal

"doug" a écrit dans le message
de news:
...
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



.

formatting text boxes
 

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

--
Regards,
Tom Ogilvy

"Doug" wrote in message
...
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!!
-----Original Message-----
Hi Doug
Use format:
TextBox1.Value = Format(CInt(TextBox1.Value), "# ##0 $")
HTH
Cordially
Pascal

"doug" a écrit dans le message
de news:
...
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



.