textbox

[Guest]

Hi

I want exit a textbox when entering "*" , i've succeeded to exit that
textbox but only after entering an "*" and any diiferent entry .... it
doesn't exit directly after entering the "*"

Grtz
R

 

[Wayne Morgan]

Exit to where? What are you trying to accomplish that making a Tab entry
instead of the * won't accomplish?

 

[Guest]

It has to exit one textbox en go to another.
"*" is a wildcard ... when nothing is entered the search event won't work.

There are 3 textboxes that have to be filled in to search the db. each
textbox stands for
a part of the key field. the key field format is "0000.000.000"
the first textbox has to be "0000" or "*"
the second and thirth "000" or "*"

grtz
R

 

[Wayne Morgan]

I just tried this and it appeared to work.

Private Sub Text0_Change()
If Me.Text0.Text = "*" Then
Me.Text2.SetFocus
End If
End Sub

This will cause it to move whenever the text in the text box shows * by
itself, regardless if this was a single key stroke or if you typed ab* then
removed the abc. You should also be able to do this in the keypress event.