Position cursor at the end of the textbox after AfterUpdate property

[tylerg11]

I am using an unbound textbox at the top of my form for filtering purposes. The user types in a string and hits "Tab" which kicks of the filter which is defined in the AfterUpdate property. I want the focus to return to the same textbox and position the curosor after the last character. I am trying to use SelStart but not having success.

    Me.Filter = "COURSE_NAME Like '*" & Me.txtFilter & "*'"
    Me.FilterOn = True
    txtFilter.SetFocus
    txtFilter.SelStart = txtFilter.SelLength

[Dal Jeanis]

Change the last line to

    txtFilter.SelStart = len(Me.txtFilter)

[tylerg11]

Change the last line to

    txtFilter.SelStart = len(Me.txtFilter)

That didn't work either. Still keeps the cursor at the front. See below.

[Dal Jeanis]

okay, try this

Me.txtFilter.SetFocus
Me.txtFilter.SelStart = len(Me.txtFilter.Text)

That shouldn't work, but random debugging actions are occasionally better than inaction.

[June7]

Try putting that last line in txtFilter GotFocus event (without Text property).

[tylerg11]

okay, try this

Me.txtFilter.SetFocus
Me.txtFilter.SelStart = len(Me.txtFilter.Text)

That shouldn't work, but random debugging actions are occasionally better than inaction.

Same result. I have been trying different things but still getting the same result. Thanks anyway.

[tylerg11]

Try putting that last line in txtFilter GotFocus event (without Text property).

Tried this too and no luck.

[June7]

Code works for me. If you want to provide db for analysis, follow instructions at bottom of my post.

[Dal Jeanis]

Okay, then I'm betting you have a timing problem. Try a time-waster before the setfocus command. Just do a 1000 rep do loop.

[sneuberg]

For reasons unknown you can't directly set focus in an afterupdate to the control that triggered the afterupdate event. As a work around you can set the focus to some other control and then to the control that fired the event, e.g.,

Me.SomeOtherControl.SetFocus 'Hopeful you have one that's visible
Me.txtFilter.SetFocus

This work around could mess up other things. For example if txtFilter has focus and has been updated (changed) and you click on a button the focus will end up on txtFilter but the buttons code will not be executed. You get sticky buttons. You have to click them twice.