input mask

[icemonster]

so you know how it is when you put an input mask it would select where you actually were clicking? is there a way when you click on a field with input mask, it would first select the first character on the left? or select them all?

 

[missinglinq]

When using Input Masks, you have to be sure to use code like this to assure that if the user clicks on the textbox the cursor will go to the beginning of the field. Otherwise the insert point will be wherever they clicked in, and they'll waste time redoing it!

Private Sub YourTextBoxName_Click()
   Me.YourTextBoxName.SelStart = 0
End Sub

If your Access default for Entering a Field is set to anything other than "Go to start of field," also use this

Private Sub YourTextBoxName_GotFocus()
  Me.YourTextBoxName.SelStart = 0
End Sub

Also use this second if you're going to be distributing your database to multiple machines. That way the users can have the Entering a Field behavior set to their own preference for other DBs.

Linq ;0)>