Simple validation rule question

[dzirkelb]

I have a text field that is entered in by my users...it has to be a letter followed by 6 numbers...how do I go about ensuring this is entered in correctly in the validation rule portion of the text box?

 

[trucktime]

Validation

You could use an Input mask:

L000000

 

[dzirkelb]

That works our perfectly! Now, how do I get teh focus upon entering in the text box to be on the left hadn side? currently, it is on the right and the user has to click Home or left arrow to get to the beginning.

 

[trucktime]

Solution

In the On Click Event of the box put:

Me.txtname.SelStart = 0

(replace txtname with the actual name of the box)

 

[dzirkelb]

Perfect! Thanks a Ton!!!

 

[trucktime]

Great

You're welcome.

 

[dzirkelb]

blarg! I was just told that it is different now (gotta love it!!)

Now it need it to be at least 6 characters and no more than 7 characters. Any idea on how to do this one?

 

[trucktime]

Mask

You may want to check this link:

http://office.microsoft.com/en-us/assistance/HP051875501033.aspx

 

[dzirkelb]

awesome link!! That made it exactly what I needed (A00000)...and, i bookmarked it. Thanks!