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 / General 2 / January 2008

Tip: Looking for answers? Try searching our database.

Changing the way you navigate through a table

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Amanda - 18 Jan 2008 15:06 GMT
Hello,
I am wondering if there is a way to have the enter key move you down to the
next cell in the column, as opposed to over to the next cell in the row.

Thanks.
Jeff Boyce - 18 Jan 2008 15:29 GMT
This newsgroup supports Microsoft Access.

It sounds like you're working in a spreadsheet.  Try one of those
newsgroups...

Regards

Jeff Boyce
Microsoft Office/Access MVP

> Hello,
> I am wondering if there is a way to have the enter key move you down to
> the
> next cell in the column, as opposed to over to the next cell in the row.
>
> Thanks.
Amanda - 18 Jan 2008 15:56 GMT
I am working in a table in Access.

> This newsgroup supports Microsoft Access.
>
[quoted text clipped - 12 lines]
> >
> > Thanks.
Jeff Boyce - 18 Jan 2008 18:30 GMT
Amanda

Access tables may look like spreadsheets but they aren't.  Access tables
store data, but they don't work as well as Access forms for data entry.

You've described "how" you are trying to do something, but not "what".  If
you'll describe a bit more specifically what being able to do what you
posted will allow you/your users to do, the folks  here in the groups may be
able to offer a more functional alternative.

Regards

Jeff Boyce
Microsoft Office/Access MVP

>I am working in a table in Access.
>
[quoted text clipped - 15 lines]
>> >
>> > Thanks.
Gordon Jones - 18 Jan 2008 16:18 GMT
Go to Tools > Options > Keyboard > "Move After Enter" and select "Next
Record".  However, if you are using forms for other users, this can create
two problems - the user might not want to go to the next record, and you
might have a default key on the form which would be activated by the <enter>.
Signature

Gordon Jones

> Hello,
> I am wondering if there is a way to have the enter key move you down to the
> next cell in the column, as opposed to over to the next cell in the row.
>
> Thanks.
Amanda - 18 Jan 2008 19:32 GMT
Gordon, that worked perfectly. Thank you.

> Go to Tools > Options > Keyboard > "Move After Enter" and select "Next
> Record".  However, if you are using forms for other users, this can create
[quoted text clipped - 6 lines]
> >
> > Thanks.
 
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



©2009 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.