input mask

[slimjen]

Two part question;related

All, using access 2010. I have a SSN search field. I used the input mask to format like:
000\-00\-0000;0;_Users are complaining that they are getting “invalid text entered” when they are inputting the correct data. I found that they are not starting at the beginning. When they click in the box; it doesn’t force them to go to the beginning of the field. So; they if they are not paying attention; they get the error. I know this is user error but how can I format so when they click in the box to begin the search; they are at the beginning of the field?

Also; I use input mask format when they enter a new record. They do not want to have to put the hyphens in when typing the SSN. But if they put without the hyphens; they are not able to search the record because the search field is formatted input mask. Is there another solution? Thanks

[June7]

Check out SelStart method.

Private Sub controlname_GotFocus()
Me.controlname.SelStart = 0
End Sub

Did you set the input mask in table? I never make property settings such as Format and Lookup in table, only in controls on forms and reports.

What is the code that performs the search? Format the user input and use that for the search criteria.

Format(Me.tbxSSN, "###-##-####")

[Dal Jeanis]

Your users shouldn't have to pay attention. That's what computers are for.

First, unformat the search field. If for technical reasons you need to use a formatted version for the search, then create a hidden control with the formatted version of the SSN, and have the AfterUpdate event of the text box cause the formatted, hidden field to get calculated. The advantage to this approach is that, if some user wants to type in the dashes, they can, and your after-update calculation routine can deal with it appropriately.

Second, use the same method with an unbound SSN entry field on the data entry screen. That field's after update will update the BOUND field's SSN.

Third, it's a tossup whether you should store the dashes in the SSN field on the database. If there is any other kind of ID stored in the same field, especially with alpha characters - EIN or such - then you should store the dashes. If not, then pure numeric is probably better.

[Missinglinq]

This would drive Mister Spock crazy, because as illogical as it seems,

Private Sub controlname_GotFocus()
 Me.controlname.SelStart = 0
End Sub

is not going to solve the problem of users 'clicking' into the Textbox at somewhere other than the beginning of the Textbox! The code has to go into the OnClick event of the Control:

Private Sub ControlName_Click()
 Me.ControlName.SelStart = 0
End Sub

Linq ;0)>

[June7]

Maybe need it in both events.

[slimjen]

Ok. thank you for all the responses. I'll try and post back.

[June7]

Correction, since you want the start position at 0, don't need GotFocus event, just use the Click as Linq suggested.

I have some controls where we want the start to be on 6th character so I do need the GotFocus event.

[Missinglinq]

Maybe need it in both events.

I actually put it in both, on the rare occasion when I use an Input Mask. The problem, on a distributed app, is that you have no way to know how a given user has the 'Behavior on Entering Field' Option set! If it's not set to 'Go to start of field,' you have the same even when Tabbing into the Field! Placing the code in the GotFocus event solves that. All in all, Inputs Masks are usually more trouble than they're worth! I'd rather take the time to Format after the data is entered
, but that's just me!

Linq ;0)>