Issues with forms and set focus

[princesstech]

Hi,

I have a form with several text boxes. At least one of those text boxes is set to validate on exit, generate an error message then return the cursor to the text box so the EU can make the correction.

Here's the code I'm using, and I can't find anything wrong with it.

Private Sub TextBox2_Exit(ByVal Cancel As MSForms.ReturnBoolean)
If TextBox2 = "" Then
MsgBox "fill it in"
TextBox2.SetFocus
End If
End Sub

What am I doing wrong? Any help would be appreciated.

TIA

Marie

 

[TommyGun]

Try placing the same code in an AfterUpdate event instead, and see if that helps.

 

[princesstech]

Thanks for the suggestion, but I tried that too, and still no luck

Marie

 

[Andrew Poulsom]

Try putting the code in the OK button click event procedure instead:

Private Sub CommandButton1_Click()
    If TextBox2.Value = "" Then
        MsgBox "fill it in"
        TextBox2.SetFocus
        TextBox2.SelStart = 0
    Else
'       Whatever
    End If
End Sub

 

[princesstech]

Thanks Andrew,

It works in the click event, however I have about 5 fields that need to be validated as soon as the user leaves that field because they are used to validate other fields, which is why I need the focus to go back to the field that is not entered correctly so they can fix the problem before going to the next field.

Marie

 

[Andrew Poulsom]

Well, maybe you can approach it this way:

Private Sub TextBox2_Enter()
    If TextBox1.Value = "" Then
        MsgBox "Fill me in"
        TextBox1.SetFocus
    End If
End Sub

 

[princesstech]

That made it a little clearer as to what is happening but it still doesn't work.

I run that code and here's what happens.

Senario 1 : From Textbox2 click on textbox1 The message pops up and the focus jumps to textbox1 as it should

Senario 2: From Textbos2 click on textbox3 you get the message, click ok, and you get the message again, then the focus jumps to textbox1 as specified in the code.

Marie

 

[Andrew Poulsom]

I don't know why you should be getting the message when you click on TextBox3.

The event procedure is for TextBox2. Why does it fire when you click TextBox3?

 

[princesstech]

It fires when I leave textbox 2, whether that be by clicking on another text box, or tabbing out.

 

[princesstech]

Sorry my bad , I had forgotten to change the code from exit to enter. The focus is right when you use the code you posted, but it doesn't validate if the box is empty when you leave the box, it just reminds you to fill it in.

Marie