Selecting Text In a Textbox

[gharabed]

An embarrasingly simple question but...I am validating the value entered in a textbox. How do I set the focus back to the text box and highlight the text entered into the textbox so all the user has to do is simply type in the correct value?

I tried using: Me![MyTextBox].SetFocus
but it didn't do anything. My warning msgbox displayed but the cursor navigated to the next textbox as if I never issued the SetFocus call.

Thanks,
Greg

 

[jebry]

Hi Greg!

It is probably the event procedure you used. Try this:

Private Sub YourTextBox_BeforeUpdate(Cancel As Integer)

If (Put your conditions here) Then
Call MsgBox("YourMessage&quot
Cancel = -1
End If

End Sub

hth
Jeff Bridgham
bridgham@purdue.edu

 

[gharabed]

That pretty much did it. Now the only question is...How do I hilight the text in the textbox programatically?

 

[gharabed]

Nevermind...I figured it out:

ctlObj.SelStart = 0
ctlObj.SelLength = Len(ctlObj)