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.
Editing Technique | Keystrokes |
---|---|
Move insertion point within a control | Press the right-arrow (→) and left-arrow (←) keys |
Insert a value within a control | Select the insertion point and type new data |
Select the entire text in a control | Press F2 |
Replace an existing value with a new value | Select the entire field and type a new value |
Replace value with value of preceding field | Press Ctrl+’ (single quotation mark) |
Replace current value with default value | Press Ctrl+Alt+Spacebar |
Insert current date into a control | Press Ctrl+; (semicolon) |
Insert current time into a control | Press Ctrl+: (colon) |
Insert a line break in a Text or Memo control | Press Ctrl+Enter |
Insert new record | Press Ctrl++ (plus sign) |
Delete current record | Press Ctrl+- (minus sign) |
Save current record | Press Shift+Enter or move to another record |
Toggle values in a checkbox or option button | Spacebar |
Undo a change to the current control | Press Esc or click the Undo button |
Undo a change to the current record | Press 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.