Chapter 8: Working with Data on Access Forms
295
The record number displayed in the Navigation controls is just an indicator of the current record’s
position in the recordset and changes every time you filter or sort the records. To the right of the
record number is the total number of records in the current view. The record count may not be the
same as the number of records in the underlying table or query. The record count changes when
you filter the data on the form.Changing Values in a Form
Earlier in this book, you learned datasheet techniques to add, change, and delete data within a
table. These techniques are the same ones you use on an Access form. Table 8.2 summarizes these
techniques.TABLE 8.2
Editing 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 contents of a control Press F2
Replace an existing value with a new value Select the entire field and enter a new value
Replace a value with value of the preceding field Press Ctrl+’ (single quotation mark)
Replace the current value with the default value Press Ctrl+Alt+Spacebar
Insert the current date into a control Press Ctrl+; (semicolon)
Insert the current time into a control Press Ctrl+: (colon)
Insert a line break in a Text or Memo control Press Ctrl+Enter
Insert a new record Press Ctrl++ (plus sign)
Delete the current record Press Ctrl+– (minus sign)
Save the current record Press Shift+Enter or move to another record
Toggle values in a check box 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