Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms / February 2006

Tip: Looking for answers? Try searching our database.

Enter Key behaviour

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Paul Hammond - 17 Oct 2005 15:20 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
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.