On 99% of the people who use a handy-dandy application I’ve set up, when they hit the Enter key on an input form, the cursor goes to the next field on the form. However, on this one person’s machine, instead of going to the next field, it goes to a new record. It’s not possible to get this user to change their Tools/Options/Keyboard, so is there a way to set the keyboard option to move to the next field and not the next record when this form is opened? It’s driving everyone crazy.
![]() |
Patch reliability is unclear. Unless you have an immediate, pressing need to install a specific patch, don't do it. |
SIGN IN | Not a member? | REGISTER | PLUS MEMBERSHIP |
-
control keyboard behavior (Access 97 (SR2))
Home » Forums » AskWoody support » Productivity software by function » MS Access and database help » control keyboard behavior (Access 97 (SR2))
- This topic has 5 replies, 4 voices, and was last updated 22 years ago.
Viewing 1 reply threadAuthorReplies-
WSHansV
AskWoody LoungerMay 8, 2003 at 2:25 pm #674808It seems strange to adapt an application that works fine for just one recalcitrant user…
You can do the following:
Open the data entry form in design view.
Set the KeyPreview property to True to handle keyboard events at the form level.
Create a KeyDown event procedure for the form:Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer)
If KeyCode = vbKeyReturn Then KeyCode = vbKeyTab
End SubThis transforms an Enter into a Tab. You will have to test whether this has undesired side effects.
When the user presses Enter or Tab in the last control in the tab order, the form will still go to the next record, unless you set the Cycle property of the form to Current Record.
-
WSSteveH
AskWoody LoungerMay 8, 2003 at 3:39 pm #674827 -
WBell
AskWoody_MVP -
WSgarbsmj
AskWoody LoungerMay 8, 2003 at 4:37 pm #674836I wish. But sadly, no.
What I did was use Han’s idea, plus (after I found I could go to a new record by hitting the Enter key past the last field on the form), I set the Cycle on the form to be “Current Record”. So now when someone
with their finger on the Enter button, they won’t end up creating 59 or so useless forms.
Hans, Steve and Wendell!
-
Viewing 1 reply thread -

Plus Membership
Donations from Plus members keep this site going. You can identify the people who support AskWoody by the Plus badge on their avatars.
AskWoody Plus members not only get access to all of the contents of this site -- including Susan Bradley's frequently updated Patch Watch listing -- they also receive weekly AskWoody Plus Newsletters (formerly Windows Secrets Newsletter) and AskWoody Plus Alerts, emails when there are important breaking developments.
Get Plus!
Welcome to our unique respite from the madness.
It's easy to post questions about Windows 11, Windows 10, Win8.1, Win7, Surface, Office, or browse through our Forums. Post anonymously or register for greater privileges. Keep it civil, please: Decorous Lounge rules strictly enforced. Questions? Contact Customer Support.
Search Newsletters
Search Forums
View the Forum
Search for Topics
Recent Topics
-
Cox Communications and Charter Communications to merge (Awaiting moderation)
by
not so anon
9 minutes ago -
Help with WD usb driver on Windows 11
by
Tex265
11 minutes ago -
hibernate activation
by
e_belmont
3 hours, 2 minutes ago -
Red Hat Enterprise Linux 10 with AI assistant
by
Alex5723
6 hours, 49 minutes ago -
Windows 11 Insider Preview build 26200.5603 released to DEV
by
joep517
9 hours, 54 minutes ago -
Windows 11 Insider Preview build 26120.4151 (24H2) released to BETA
by
joep517
9 hours, 56 minutes ago -
Fixing Windows 24H2 failed KB5058411 install
by
Alex5723
13 hours, 6 minutes ago -
Out of band for Windows 10
by
Susan Bradley
14 hours, 39 minutes ago -
Giving UniGetUi a test run.
by
RetiredGeek
21 hours, 36 minutes ago -
Windows 11 Insider Preview Build 26100.4188 (24H2) released to Release Preview
by
joep517
1 day, 5 hours ago -
Microsoft is now putting quantum encryption in Windows builds
by
Alex5723
1 day, 3 hours ago -
Auto Time Zone Adjustment
by
wadeer
1 day, 9 hours ago -
To download Win 11 Pro 23H2 ISO.
by
Eddieloh
1 day, 7 hours ago -
Manage your browsing experience with Edge
by
Mary Branscombe
11 hours, 58 minutes ago -
Fewer vulnerabilities, larger updates
by
Susan Bradley
24 minutes ago -
Hobbies — There’s free software for that!
by
Deanna McElveen
6 hours, 48 minutes ago -
Apps included with macOS
by
Will Fastie
4 hours, 40 minutes ago -
Xfinity home internet
by
MrJimPhelps
1 hour, 27 minutes ago -
Convert PowerPoint presentation to Impress
by
RetiredGeek
1 day, 2 hours ago -
Debian 12.11 released
by
Alex5723
2 days, 6 hours ago -
Microsoft: Troubleshoot problems updating Windows
by
Alex5723
2 days, 10 hours ago -
Woman Files for Divorce After ChatGPT “Reads” Husband’s Coffee Cup
by
Alex5723
1 day, 13 hours ago -
Moving fwd, Win 11 Pro,, which is best? Lenovo refurb
by
Deo
1 minute ago -
DBOS Advanced Network Analysis
by
Kathy Stevens
3 days, 3 hours ago -
Microsoft Edge Launching Automatically?
by
healeyinpa
2 days, 17 hours ago -
Google Chrome to block admin-level browser launches for better security
by
Alex5723
15 hours, 35 minutes ago -
iPhone SE2 Stolen Device Protection
by
Rick Corbett
2 days, 22 hours ago -
Some advice for managing my wireless internet gateway
by
LHiggins
2 days, 5 hours ago -
NO POWER IN KEYBOARD OR MOUSE
by
HE48AEEXX77WEN4Edbtm
1 day, 7 hours ago -
A CVE-MITRE-CISA-CNA Extravaganza
by
Nibbled To Death By Ducks
3 days, 15 hours ago
Recent blog posts
Key Links
Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.
Mastodon profile for DefConPatch
Mastodon profile for AskWoody
Home • About • FAQ • Posts & Privacy • Forums • My Account
Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts
Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.