Access 2007 forms stuck on "New line in field"

[M Skabialka]

In Access 2007 I have created some forms and sub-forms for data entry. When
a user enters data in the field and hits enter, they are given a new line in
the field instead of going to the next field. The only two options under
'Enter key behavior' are 'New line in field' or 'Default'. When I select
default and they hit enter, nothing happens - they are left in the same
position in the same field. Most of the fields are text fields.
I would like it to go to the next field, as it used to in prior versions. I
am looking at 'Enter key behavior' properties on the field itself.

 

[Albert D. Kallal]

I never experienced your problem in 2007, it works for me like it always
did.

I would check if you removed the tab stop setting for the control. If none
on the controls have the "tab stop" property set to yes, then you will find
that tab (or enter) will NOT move to the next control. And, if there only
one control on the form with a tab stop you again not move anywhere.

Keep in mind, while the enter key can be set to go to the next field, since
windows 3.1 (17 years ago), the standard in windows (and now even web
browsers) has been to use the tab key to go to the next field.

The other thing to check is the settings you have for the Enter key.

office button-> Access options-> advanced

You see a section called

Move after enter
[ ] Don't Move
[x] Next Field
[ ] Next Record

The above settings also exist in access 2003 also. Perhaps you been messing
with the above settings as this can turn off enter key going to next
control. This probably the first thing I would check.