O'Reilly logo

Office 2007 Bible by Lisa A. Bucki, Gavin Powell, Michael R. Irwin, Peter G. Aitken, Michael R. Groh, Cary N. Prague, Faithe Wempen, Herb Tyson, John Walkenbach

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Changing Values in a Form

You can add, change, and delete data within a table by using a form. Table 35-4 summarizes these techniques.

Table 35-4. Editing Techniques
Editing TechniqueKeystrokes
Move insertion point within a controlPress the right-arrow (→) and left-arrow (←) keys
Insert a value within a controlSelect the insertion point and type new data
Select the entire text in a controlPress F2
Replace an existing value with a new valueSelect the entire field and type a new value
Replace value with value of preceding fieldPress Ctrl+’ (single quotation mark)
Replace current value with default valuePress Ctrl+Alt+Spacebar
Insert current date into a controlPress Ctrl+; (semicolon)
Insert current time into a controlPress Ctrl+: (colon)
Insert a line break in a Text or Memo controlPress Ctrl+Enter
Insert new recordPress Ctrl++ (plus sign)
Delete current recordPress Ctrl+- (minus sign)
Save current recordPress Shift+Enter or move to another record
Toggle values in a checkbox or option buttonSpacebar
Undo a change to the current controlPress Esc or click the Undo button
Undo a change to the current recordPress Esc or click the Undo button a second time after you Undo the current control

Controls that you can’t edit

Some controls can’t be edited, such as:

  • Controls displaying AutoNumber fields: Access maintains AutoNumber fields automatically, calculating the values as you create each new record.

  • Calculated controls: Access uses calculated controls in forms or queries; these values are not actually ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required