By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,606 Members | 3,802 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,606 IT Pros & Developers. It's quick & easy.

Access 2000 Enter key causes carriage return, not next field, in datasheet view

P: n/a
Hello all,

I am using Access 2002, with file format of Access 2000, and am
experiencing a problem.

I have a subform that is shown in datasheet view for users to edit data
direct to a table.

When a user presses the Enter (or Return) key a carriage return is made
in the cell, rather than the cursor moving to the next field, which is
what I expected to happen. (I believe that usually, to create a
carriage return, the user would have to press Control+Enter.)

Is there a way of preventing the carriage return and forcing the Enter
key to move the cursor to the next field?

Under the Options, Keyboard Tab, the 'Move after enter' setting is set
to "Next field".

Is there an option on the form or subform that is causing this change
in behaviour?

Many thanks in advance for any help.


Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply

P: n/a
Hi again,

I have found a solution to my problem:

On the sub form (design view) some of the controls had their 'Enter Key
Behavior' property set to "New Line in Field". Changing this to
"Default" solved the issue.


Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.