To fill in a blank field, first click on it or go to it using the Enter key. This will make it the active cell. Next, just type in or select the appropriate data for that field, according to the data type you set for the field.
To change the contents of a field, first go to it either by clicking in the field or using the Enter key. There are three possible operations you might want to perform on the cell:
delete the contents
replace the contents
edit or add to the contents.
With most types of field you can click at the position in the field where you want to edit, or append new text to, the current contents. To replace or delete the current contents, double-click in the field to select the field contents and then type replacement text or press Del (if you entered the field using the Enter key, you can delete or replace text without clicking).
The method of editing fields depends to some extent on the data type of the field:
Character, Memo and Numeric fields are straightforward and their contents can be edited, deleted or replaced, as outlined in the previous paragraph.
With other fields the procedure is slightly different but just as obvious:
Enumerated: delete the contents by double-clicking in the field to select the contents and then press Del. Enter one of the members of the enumerated list by clicking on the arrow and selecting the appropriate one from the drop-down list, or alternatively type it yourself directly (what you type will only be entered if it is in the enumerated list).
Logical: you can't delete the contents of a logical field but only change the field’s value. If you try to delete the contents, they will be restored to the default value (No, False, Off or 0) as soon as you move to another record.
Date: delete the contents by double-clicking in the field to select the contents and then press Del. Type the date according to the format you set when creating the field. The field will only accept dates that match the chosen format.
Time: delete the contents by pressing Del. Type the time according to the format you set when creating the field. The field will only accept times that match the chosen format.
Incremental: the contents of this field can't be edited or deleted. Incremental values are set when you format the field and are one way of uniquely identifying a record. If you delete an incremental value you won't be able to move out of the current record. To restore the value, press Esc. An incremental value can only be deleted by deleting the row in which it occurs.
Calculated: the contents of this field are determined by the formula you set and therefore can’t be edited or deleted. The only way to change the contents is to change the contents of the fields that are referred to in the formula. Deleting the formula in Table Format will of course remove all the results that are calculated by the formula.
OLE: delete an OLE object by pressing Del. Insert an OLE object by double clicking in the field to display the OLE Table. Select either File (to insert an existing file) or New Object (to insert a new object) from the Insert menu (see OLE data type).
Usually, when you are editing fields, you can abandon the current edit by pressing the Esc key. The field will revert to its previous state.
After editing a field’s contents, click on the field you want to edit next (or use the cursor movement keys).