Move to next control in Form after pressing Enter?

[Terry]

I have a form which is displayed in Datasheet View and would prefer it
if, when entering data, I could use the keyboard as I would when
entering data into a Datasheet.

Is it possible when entering data into a form to get the cursor to
move to the next control after I press the Enter key?

Terry

[Rick Brandt]

"Terry" <tc*****@merseymail.com> wrote in message
news:38**************************@posting.google.c om...

I have a form which is displayed in Datasheet View and would prefer it
if, when entering data, I could use the keyboard as I would when
entering data into a Datasheet.

Is it possible when entering data into a form to get the cursor to
move to the next control after I press the Enter key?

By default that is what the <Enter> key does. What is it doing on your PC?
Perhaps you just have to adjust your Tab order.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

[Deano]

Terry wrote:

I have a form which is displayed in Datasheet View and would prefer it
if, when entering data, I could use the keyboard as I would when
entering data into a Datasheet.

Is it possible when entering data into a form to get the cursor to
move to the next control after I press the Enter key?

Terry

Change the cycle property of the form to Current Record.

[Tom van Stiphout]

On Sat, 20 Dec 2003 18:39:23 -0600, "Rick Brandt"
<ri*********@hotmail.com> wrote:

But only if no button has its Default property set to True.
Better to teach users that Tab moves the cursor from field to field,
and Enter clicks the Default push button. Why fight the way Windows
was designed to operate?

-Tom.

"Terry" <tc*****@merseymail.com> wrote in message
news:38**************************@posting.google. com...

I have a form which is displayed in Datasheet View and would prefer it
if, when entering data, I could use the keyboard as I would when
entering data into a Datasheet.

Is it possible when entering data into a form to get the cursor to
move to the next control after I press the Enter key?

By default that is what the <Enter> key does. What is it doing on your PC?
Perhaps you just have to adjust your Tab order.

[Rick Brandt]

"Tom van Stiphout" <to*****@no.spam.cox.net> wrote in message
news:d0********************************@4ax.com...

On Sat, 20 Dec 2003 18:39:23 -0600, "Rick Brandt"
<ri*********@hotmail.com> wrote:

But only if no button has its Default property set to True.
Better to teach users that Tab moves the cursor from field to field,
and Enter clicks the Default push button. Why fight the way Windows
was designed to operate?

The OP did specify Datasheet view. There would be no such button then no?
Actually that's a question I'll have to test. Does the default button still
fire if you press <Enter> in Datasheet view?
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

[Rick Brandt]

"Rick Brandt" <ri*********@hotmail.com> wrote in message
news:bs************@ID-98015.news.uni-berlin.de...

"Tom van Stiphout" <to*****@no.spam.cox.net> wrote in message
news:d0********************************@4ax.com...

On Sat, 20 Dec 2003 18:39:23 -0600, "Rick Brandt"
<ri*********@hotmail.com> wrote:

But only if no button has its Default property set to True.
Better to teach users that Tab moves the cursor from field to field,
and Enter clicks the Default push button. Why fight the way Windows
was designed to operate?

The OP did specify Datasheet view. There would be no such button then no?
Actually that's a question I'll have to test. Does the default button still
fire if you press <Enter> in Datasheet view?

The result of my test is no it does not (A97).
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com

[Terry]

"Deano" <de*********@hotmail.com> wrote in message news:<%_******************@wards.force9.net>...

Terry wrote:

I have a form which is displayed in Datasheet View and would prefer it
if, when entering data, I could use the keyboard as I would when
entering data into a Datasheet.

Is it possible when entering data into a form to get the cursor to
move to the next control after I press the Enter key?

Terry

Change the cycle property of the form to Current Record.

I found the solution:-)

What was actually happening when I pressed the Enter Key was that I
was creating a new line, but this wasn't apparent as the text boxes
are narrow. Hence I thought that something odd was happening with the
form's properties.

When I looked at Properties, Other in each Text Box I found that Enter
Key Behaviour was set to 'New Line in Field' so I changed it to
Default and now the cursor goes to the next control when I press the
Enter Key.

Thanks for your help
Terry