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

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.

Who is Participating?
Rey Obrero (Capricorn1)Commented:
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
Patty01AccessAuthor Commented:
That's it!! Thanks much Capricorn!

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.