Microsoft Office Online
Sign in to My Office Online (What's this?) | Sign in

 
 
Microsoft Office Access
Search
Search
 
Check for updates: (c) Microsoft
Office downloads
 
 
 
Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.

Email this linkEmail this link Printer-Friendly VersionPrinter-Friendly Version Bookmark and ShareShare
Check spelling
 

ShowCheck the spelling of data in Datasheet view

  1. Open a datasheet (datasheet: Data from a table, form, query, view, or stored procedure that is displayed in a row-and-column format.).
  2. Select the records, columns, fields, or text whose spelling you want to check.

    ShowHow?

    The following table lists mouse techniques for selecting data or records in Datasheet view (Datasheet view: A window that displays data from a table, form, query, view, or stored procedure in a row-and-column format. In Datasheet view, you can edit fields, add and delete data, and search for data.).

    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 Button image.
    Adjacent fields The left edge of a field and drag to extend the selection.
    A column The field selector (field selector: A small box or bar that you click to select an entire column in a datasheet.).
    Adjacent columns The field name at the top of the column and then drag to extend the selection.
    A record The record selector (record selector: A small box or bar to the left of a record that you can click to select the entire record in Datasheet view and Form view.).
    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.
  3. Click Spelling Button image on the toolbar (toolbar: A bar with buttons and options that you use to carry out commands. To display a toolbar, click Customize on the Tools menu, and then click the Toolbars tab.).

Note   If a datasheet contains subdatasheets (subdatasheet: A datasheet that is nested within another datasheet and that contains data related or joined to the first datasheet.), Microsoft Access checks the spelling only of the datasheet or subdatasheet where you have placed the insertion point.

ShowCheck the spelling of data in Form view

  1. Open a form in Form view (Form view: A window that displays a form to show or accept data. Form view is the primary means of adding and modifying data in tables. You can also change the design of a form in this view.).
  2. Select the field or text whose spelling you want to check.
  3. Click Spelling Button image on the toolbar.

ShowCheck the spelling of the data in a database object while in the Database window

  1. In the Database window (Database window: The window that appears when you open an Access database or an Access project. It displays shortcuts for creating new database objects and opening existing objects.), click the table, query, form, view, or stored procedure whose spelling you want to check.
  2. Click Spelling Button image 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.

advertisement