Input Mask - Annoying behavior.

[ApexData]

I have an unbound textbox that I want to restrict to 10 characters.
I defined the mask as follows CCCCCCCCCC;;" "
The problem is that the behavior of the cursor changed beyond my
request.
Normally, you click on an empty txtbox without the mask and the cursor
goes to the first position.
With a mask this is not the case.

Additionally, if you have a one character txtbox mask set to C;;" " ,
it becomes very easy to inadvertently click on the wrong side of the
entrybox. This results in an annoying beep that convinces the user
that something is wrong and they cannot enter data, when in fact they
are off to the right by one character.

Any way to control this, so the cursor goes to the first postion when
the box is empty?
I do have to restrict the number of characters entered. So I think I
need the mask?
Appreciate tips or suggestions.

Greg

[Baz]

Input masks ARE annoying, I never use them.

You could have this as a Validation Rule:

Like "??????????"

<Ap******@gmail.comwrote in message
news:11**********************@51g2000cwl.googlegro ups.com...

I have an unbound textbox that I want to restrict to 10 characters.
I defined the mask as follows CCCCCCCCCC;;" "
The problem is that the behavior of the cursor changed beyond my
request.
Normally, you click on an empty txtbox without the mask and the cursor
goes to the first position.
With a mask this is not the case.

Additionally, if you have a one character txtbox mask set to C;;" " ,
it becomes very easy to inadvertently click on the wrong side of the
entrybox. This results in an annoying beep that convinces the user
that something is wrong and they cannot enter data, when in fact they
are off to the right by one character.

Any way to control this, so the cursor goes to the first postion when
the box is empty?
I do have to restrict the number of characters entered. So I think I
need the mask?
Appreciate tips or suggestions.

Greg

[missinglinq via AccessMonster.com]

Greg,

I agree with Baz in that input masks can be annoying, but they are sometimes
necessary! The secret to using an input mask is to also have this code in the
OnClick sub for the textbox:

Private Sub YourTextBoxNameGoesHere_Click()
YourTextBoxNameGoesHere.SelStart = 0
End Sub

This insures that when you click on the field the cursor goes to the
beginning and not where the cursor was when you clicked into it.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/200701/1

[ApexData]

Thanks for the response.

Private Sub YourTextBoxNameGoesHere_Click()
YourTextBoxNameGoesHere.SelStart = 0
End Sub

The suggested code works fine for a bound textbox, but these are
unbound and it does not work!
Maybe I should create a BogusTable for my entry form???
Greg