- Open a datasheet.
- Select the records, columns, fields, or text whose spelling you want to check.
The following table lists mouse techniques for selecting data or records in Datasheet view.
To select Click Data in a field Where you want to start selecting and drag across the data. An entire field The left edge of the field in a datasheet, where the pointer changes into . Adjacent fields The left edge of a field and drag to extend the selection. A column The field selector. Adjacent columns The field name at the top of the column and then drag to extend the selection. A record The record selector. Multiple records The record selector of the first record, and then drag to extend the selection. All records Select All Records on the Edit menu. - Click Spelling on the toolbar.
Note If a datasheet contains subdatasheets, Microsoft Access checks the spelling only of the datasheet or subdatasheet where you have placed the insertion point.
Check the spelling of data in Form view
- Open a form in Form view.
- Select the field or text whose spelling you want to check.
- Click Spelling on the toolbar.
Check the spelling of the data in a database object while in the Database window
- In the Database window, click the table, query, form, view, or stored procedure whose spelling you want to check.
- Click Spelling on the toolbar.
Note In the Spelling dialog box, click Add if you want to add the word that is in the Not In Dictionary box to the custom dictionary.