textbox formatting

[Guest]

How can I format a textbox to show a decimal to 2 places. My textob will show
correctly when the amount has chage, but on even dollars the .oo is lost.
Formatting the controlsource cells doesn't seem to help.

Is there a way to 'reload' a textbox on a form without 'reloading' the whole
userform? I posted a problem yesterday about a problem with textboxes not
updating unless the userform was reloaded but I dont like the flash and delay
that causes.

Thanks to all
Christy

 

[Tom Ogilvy]

Textbox1.Value = format(cdbl(textbox1.value),"#.00")

 

[Guest]

Thanks again Tom

Textbox1.Value = format(cdbl(textbox1.value),"#.00")