Use the Keyboard to Move Up and Down Between Records

In this video I'll show you how you can use keyboard shortcuts to navigate up and down through records in your Microsoft Access databases.

Juan from Yokosuka Navy Base, Japan (a Gold Member) asks: I would like to be able to move up and down in my continuous forms just like an Excel spreadsheet using the keys. Is this possible in Access? Right now the up and down arrows just move between fields.

Members

I'll show you how to use the KeyPreview form property to intercept special keys, like the arrow keys. We'll learn about the KeyPress and KeyDown events and the special KeyCode constants. We'll make your form truly behave like an Excel spreadsheet where users can move up, down, left, and right with the arrow keys.

•  Extended Cut Video - Silver
• Database Template Download - Gold

Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the files from class plus get access to the Code Vault. If you're not a member, Join Today!

Links

Continuous Forms: https://599cd.com/Continuous
KeyPress Event: https://599cd.com/KeyPress
KeyDown Event: https://599cd.com/KeyDown
Search As You Type: https://599cd.com/SearchAsYouType

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.

Keywords

keypress, keydown, keycode, keypreview, move with arrow keys, acKeyUp, acKeyDown