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

Get Office 2007 Bible now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.