Validation not working properly

[Damian37]

Hello all,
I've written a validation check to make sure users using a userform enter a valid employee ID or kiosk number, but also to prevent the users from leaving the box blank. The coding was working, but now it only seems to be working intermittently. When testing there are times when I leave the box blank, my msgbox message comes up, but the majority of times, nothing happens. Does anyone know why this may be occurring, or how I can add another validation to ensure the user cannot enter an invalid employee id #, kiosk #, or leave the field blank? I also thought, if the user entered a value that was invalid, my setFocus line would take them back to the PERNR text box, instead it places the cursor within the next box they would enter, which is the Rep name box. Here's a snippet of the code I'm using:

Please Login or Register  to view this content.

Thanks for any and all help!
Damian37

[judgeh59]

Is it possible that spaces are getting put in....because a space would not be trapped by your IF statement....you could change the Me.txtPERNR.Text to TRIM( Me.txtPERNR.Text) = "" and that might work....If spaces are causing your problem...HTH

[Damian37]

Is it possible that spaces are getting put in....because a space would not be trapped by your IF statement....you could change the Me.txtPERNR.Text to TRIM( Me.txtPERNR.Text) = "" and that might work....If spaces are causing your problem...HTH

Thanks judgeh59,
The Trim appears to be working. One thing, I would like the cursor to go back to the textbox in which they would be entering in the PERNR # or kiosk entry # if they entered in an incorrect value. Right now the cursor goes to the next box they would be entering data after they click ok within the msgbox. I thought my setFocus line would make the cursor go back to the PERNR box, but it isn't doing that. Any ideas why that might be? Here's my updated code:

Please Login or Register  to view this content.

[judgeh59]

the only thing I can think of is to put the setfocus after the msgbox....

[judgeh59]

did that fix the problem?

[Damian37]

did that fix the problem?

Hi judgeh59,
Unfortunately, no it didn't. The cursor is still moving on to the next text box even though a valid entry hasn't been completed within the PERNR text box. Still researching, but also working on a few other things right now. The validation is forcing the user to enter in a correct value, so my userform is working, just not perfectly. Thanks for checking up!

Damian37

[judgeh59]

hmmmm....weird....the only other way to help would be to upload the file....if you want....if you do be sure to delete/change any company sensitive data....