Move to the first character in a text box after update.

Posted on 2012-08-22
Last Modified: 2012-08-22
I am building an input box for entering a 6 character string. This code can be scanned or entered by hand. To speed up entering this information when scanning I want it to return to the first position ready to accept new input as soon as the "After Update" event triggers. The text box is setup to autotab after the last character is entered so there is no need to do anything but scan the next character string on the list.

I thought it would be as simple this... but it is not working?

With Me!txtWONum
    .SelStart = 0

End With

Fast help gets fast fat points!

Question by:Jeffrey Reep
    LVL 12

    Accepted Solution

    I think you can use

    sendkeys "{HOME}"

    after .setfocus

    Here some info

    Author Closing Comment

    by:Jeffrey Reep
    Great! That works... Not a fan of send keys so if anybody has a better method please let me know and I'll add some points to the pot!

    Thanks for the quick response.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    The first two articles in this short series — Using a Criteria Form to Filter Records ( and Building a Custom Filter ( — discuss in some detail how a form can be…
    Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
    Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
    In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    12 Experts available now in Live!

    Get 1:1 Help Now