Adding leading zeros to a text box

[fbiasi]

Hi there,

I have a user form, with a text box for the user to input a purchase order number.
I would like to have the user type in a 3-digit number (001, 010, 100), but have
the entry displayed as FB-2013-001, or FB-2013-010, or FB-2013-100.

what is the code to have the 'FB-2013-' part of the display be automatic and not
have the user type all that in.

As I have it now, the leading zeros don't show, so I get FB-2013-1, or FB-2013-10.

Any and all help is appreciated.

frank

[Leith Ross]

Hello fbiasi,

The prefix can be added automatically using the TextBox_AfterUpdate() event. This event is fired when the user presses the Enter key or clicks on another control. Change TextBox1 to match your TextBox's name.

Please Login or Register  to view this content.

[fbiasi]

Hi Leith,

Thanks for the response.
I just tried the code and still the result doesn't show the leading zeros in the cell that is bound to the textbox.

Here is the code:

Please Login or Register  to view this content.