limit characters for form textbox?

[CarlyS]

Does anyone know a way to limit characters entered into a textbox control on a form? ( I have never written a code, so I am hoping there is some secret property setting that I don't know about). I have been able to accomplish this using an input mask, but that is a cumbersome way of doing things when the limit is 100 characters. When the person goes to type in this textbox, if they click in the middle of the box, they start typing in the middle of the box--it doesn't automatically start their text at the start of the input mask. This will cause much griping at me. Any ideas for a novice?

 

[Stingfish]

try this in the OnClick

Me.YourtxtboxName.SelStart = 0

This will always make the cursor go to the start of the first character in a text box when any one clicks in the midde or any in a textbox.

hope this what u need.

 

[CarlyS]

Thank you

That worked perfectly, I'm good to go. I appreciate your help!

 

[Mile-O]

I fail to see how that would work. In the Code Repository forum there is this solution.

 

[Stingfish]

SJ McAbney

I looks like there is 2 parts to the questions but I only provided part of the solution to his/her question . As for the limit to text box question, your link to the thread is spot on SJ McAbney.

 

[CarlyS]

Better yet!

Yes, that avoided some of the input mask problems that were still coming up. Thank you both so much!
Best,
Carly