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


--
Regards,
Tom Ogilvy


"Christy" wrote in message
...
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 ;)