Fill with zero
Long time since i used this function, but try ;
string$(10-len(yourTextbox.text),"0")
Rgds
Rog
-----Original Message-----
Hi
I have a userform and the value produced from a textbox
must be be 10
characters long, i.e. if a 3 digit figure is input, is
there a way to precede
this figure with seven zeros?
Grateful for all ideas.
.
|