text box on exit

[Souris]

I have validate code on text box and want to cursor get back text box.

I use Screen.ActiveControl.SetFocus, but the cusor goes to where my mouse
click.

Are there any way to let cursor stay in the text box until user enter valide
data?


Your help is great appreciated,

 

[fredg]

I have validate code on text box and want to cursor get back text box.

I use Screen.ActiveControl.SetFocus, but the cusor goes to where my mouse
click.

Are there any way to let cursor stay in the text box until user enter valide
data?

Your help is great appreciated,

Use the Text control's BeforeUpdate event to validate the data.

If IsNull(Me.[ControlName]) or Me.[ControlName] = "WrongData" then
MsgBox "Wrong Entry."
Cancel = true
End If

 

[Souris]

thanks millions,

I have validate code on text box and want to cursor get back text box.

I use Screen.ActiveControl.SetFocus, but the cusor goes to where my mouse
click.

Are there any way to let cursor stay in the text box until user enter valide
data?

Your help is great appreciated,

Use the Text control's BeforeUpdate event to validate the data.

If IsNull(Me.[ControlName]) or Me.[ControlName] = "WrongData" then
MsgBox "Wrong Entry."
Cancel = true
End If