How to get Enter key on numeric keypad to tab to next field in an Access 2010 Form

Posted on 2012-08-29
Last Modified: 2012-08-29
My subform does not move to the next field when it is on the first "unit type" field, when using the "Enter" key on either the regular keyboard or the numeric keypad.  If you're on the first field (1 Bed in the attached under the "Unit Type" column) and hit Enter, it just sits there.  But after that field, it works fine until you reach the beginning  of the next record.

We need to input a lot of data, and it's easiest just using the number pad.  The "tab" key works fine moving to the next field, and I'd like the "enter" key on the numeric keypad to act the same way.

Is there a way to change that?  Seems like it isn't a problem with a one-to-one relationship versus a many-to-one in this example.

Question by:Patty01Access
    LVL 119

    Accepted Solution

    in the design view of your form,
    select the textbox  Unittype and hit F4
    select the Other Tab
    locate the  Enter Key Behaviour Property and set it to Default

    Author Closing Comment

    That's it!! Thanks much Capricorn!


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    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!

    When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
    A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
    Familiarize people with the process of utilizing SQL Server stored procedures 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 Micr…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    737 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

    18 Experts available now in Live!

    Get 1:1 Help Now