Read this tip to make your life smarter, better, faster and wiser. LifeTips is the place to go when you need to know about Access and other Microsoft topics.

What are the shortcuts for entering data in datasheet or form view?

Entering Data in Datasheet or Form View

The shortcuts for entering data in a datasheet or form view are:

CTRL+SEMICOLON = Insert current date
CTRL+COLON = Insert current time
CTRL+APOSTROPHE = Insert the value from the same field in the previous record
CTRL+PLUS SIGN = Add new record
CTRL+MINUS SIGN = Delete current record
SHIFT+ENTER = Save changes to the current record
SPACEBAR = Switch between values in check box or option button
CTRL+ENTER = Insert a new line

Comments

Nobody has commented on this tip yet. Be the first.

Ask a Question

Not finding the advice and tips you need on this Microsoft Tip Site? Request a Tip Now!

Guru Spotlight

George Sayour

Ever wonder how you could make your life better and more fun? So have tens of millions of fans who have turned to LifeTips for answers over the past decade. We keep the tips, advice, books, podcasts and writing services flowing, so you can keep your life and business growing in the right direction. Upward!