How to make limit in text field please..???

Dear Expert,

I would like to create a Purchase Order form using Microsoft Words, using userform...when fill in the textfield (bookmarked form field), I can type it without limit...How to make it limited typed..For Example: in the TextBox1, how to make it limit up to 5 digits. i.e. PO001, instead of like this. i.e. weurwuerowieuroiwurwie....(in the TextBox1) and then automatically tab to the next textfield please???...

Please help me..I attached a file regarding to this matter. Please find my attached file.

Thank you for your kind helps..

Best Regards,

Jennifer :)

VB Code:

TextBox1.MaxLength = 5
TextBox1.AutoTab = True

It works...!!!...Thanks very much for your fast helps.

Best Regards,

Jennifer :thumb:

Quote:

---

Originally Posted by zach007

Dear Expert,

I would like to create a Purchase Order form using Microsoft Words, using userform...when fill in the textfield (bookmarked form field), I can type it without limit...How to make it limited typed..For Example: in the TextBox1, how to make it limit up to 5 digits. i.e. PO001, instead of like this. i.e. weurwuerowieuroiwurwie....(in the TextBox1) and then automatically tab to the next textfield please???...
Jennifer :)

---

Hi Jennifer,

To restrict the length of that field. Just right click that field select properties which will show you that form field properties. using that you can set the length, default text, text format, which macros you want to run, etc.
__________________
CS.

If a post has helped you then please Rate it!
If your post is resolved go to your original post and add the [IMG][/IMG]Message icon to your thread and/or edit the Subject and add [Resolved] or something similar.