I want to control the actions of the Enter key. I have a form that wants to
go to the next record when the Enter key is hit, but I just want it to go to
the next control till it gets to the last control, THEN go to the next record.
Please tell me there is a form property to control this.
Paul Hammond
Richmond, VA
Ofer - 17 Oct 2005 15:33 GMT
Set the Tab Order of each field, and set it to the order you want, until the
last field.
When you get to the last field in that order it will move to the next record
When you are in form design, select from the menu bar view > Tab Order, to
see the order you have now and change it to the order you want.
or change the property of each field

Signature
If I answered your question, please mark it as an answer. That way, it will
stay saved for a longer time, so other can benifit from it.
Good luck
> I want to control the actions of the Enter key. I have a form that wants to
> go to the next record when the Enter key is hit, but I just want it to go to
[quoted text clipped - 4 lines]
> Paul Hammond
> Richmond, VA
Paul Hammond - 17 Oct 2005 15:45 GMT
This is not working. Everytime I hit the Enter key it wants to go to the
next record. I have the tab order already set the way I want it. Since my
table does not allow nulls in most fields, I am getting errors.
Paul

Signature
> Set the Tab Order of each field, and set it to the order you want, until the
> last field.
[quoted text clipped - 11 lines]
> > Paul Hammond
> > Richmond, VA
Klatuu - 17 Oct 2005 16:20 GMT
From your menu bar: Tools->Options->Keyboard
Under Move After Enter, Click Next Field.
Note, this will affect all forms in your application.
> This is not working. Everytime I hit the Enter key it wants to go to the
> next record. I have the tab order already set the way I want it. Since my
[quoted text clipped - 17 lines]
> > > Paul Hammond
> > > Richmond, VA
Paul Hammond - 17 Oct 2005 16:44 GMT
Is there a way to set this programatically?
Paul
> From your menu bar: Tools->Options->Keyboard
> Under Move After Enter, Click Next Field.
[quoted text clipped - 21 lines]
> > > > Paul Hammond
> > > > Richmond, VA
Klatuu - 17 Oct 2005 16:56 GMT
There may be, but I could not find it.
> Is there a way to set this programatically?
>
[quoted text clipped - 25 lines]
> > > > > Paul Hammond
> > > > > Richmond, VA
Paul Hammond - 17 Oct 2005 17:00 GMT
Maybe the subject of a another post.
Thanks for your help.
Paul

Signature
> There may be, but I could not find it.
>
[quoted text clipped - 27 lines]
> > > > > > Paul Hammond
> > > > > > Richmond, VA
fredg - 17 Oct 2005 18:55 GMT
> I want to control the actions of the Enter key. I have a form that wants to
> go to the next record when the Enter key is hit, but I just want it to go to
[quoted text clipped - 4 lines]
> Paul Hammond
> Richmond, VA
Did you set the Form's Cycle property to All Records?
It's on the Other Tab.
Are all of the other controls enabled and not locked?

Signature
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
Paul Hammond - 17 Oct 2005 19:06 GMT
Form's Cycle property IS set to All Records
There are some controls that are locked.
Paul
> > I want to control the actions of the Enter key. I have a form that wants to
> > go to the next record when the Enter key is hit, but I just want it to go to
[quoted text clipped - 8 lines]
> It's on the Other Tab.
> Are all of the other controls enabled and not locked?
DaveInLV - 08 Feb 2006 18:50 GMT
>I want to control the actions of the Enter key. I have a form that wants to
>go to the next record when the Enter key is hit, but I just want it to go to
[quoted text clipped - 4 lines]
>Paul Hammond
>Richmond, VA
I had the identical problem with a form where I needed to edit the boxes at
random and I handled it this way. I selected Tools/Options/Keyboard in the
MS-Access toolbar and then selected "Don't move" radio button in the "Move
After Enter" box. Of course, now I have to go to the next record manually
but it works for me.
Dave