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

Posted on 2012-08-29
Medium Priority
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 120

Accepted Solution

Rey Obrero (Capricorn1) earned 2000 total points
ID: 38347820
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

ID: 38347848
That's it!! Thanks much Capricorn!


Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Suggested Courses

840 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