Enter key to go to next record

[LG]

If a form is set up to use tab keys to go to the next field. Is there a way
to set it so when they press enter it would skip the remaining fields and go
to the next record?

 

[Clifford Bass]

Hi,

Sure.

Access 2007: Office button, Access Options button, Advanced section,
Editing subsection, "Move after enter" item.

Access 2003 and earlier: Tools menu, Options item, Keyboard tab, "Move
after enter" item.

This of course impacts Access as used by the user, not just one form or
one database.

Clifford Bass

 

[LG]

I am using 2003 and had set to move to next record after enter already and
it wasn't working. Is it possible since the form

 

[Clifford Bass]

Hi,

There is something else going on that is intercepting the <Enter>.
Does either of the buttons have its Default property set to Yes? If so, that
will interpret the <Enter> as clicking on that button. Or, if the last field
has its Enter Key Behavior set to New Line in Field, that too will intercept
the <Enter>. You may also wish to check the form's On Key Up, On Key Down
and On Key Press events? Does it have them? What happens inside of them if
there are any?

If you are still baffled, if may be usefue to test to verify that it is
something specific to the current form. Creating a new form for the
recordset and test to see if <Enter> does work as desired by going to the
next record.

Clifford Bass