Microsoft KB Archive/318809

= ACC2002: Error Message: Microsoft Access Is Unable to Start the Lookup Wizard =

Article ID: 318809

Article Last Modified on 9/26/2003

-

APPLIES TO


 * Microsoft Access 2002 Standard Edition

-



This article was previously published under Q318809



Novice: Requires knowledge of the user interface on single-user computers.

This article applies only to a Microsoft Access database (.mdb).



SYMPTOMS
When you try to use the Lookup Wizard for a data type of a field, you may receive the following error message:

Microsoft Access is unable to start the Lookup Wizard. The Lookup Wizard doesn't apply to fields of this data type.



CAUSE
The data type of a field was set to something other than Text, Number, or Yes/No before you started the Lookup Wizard.



RESOLUTION
To work around this behavior, make sure that the Default field type box on the Tables/Queries tab of the Options dialog box is set to Text, Number, or Yes/No before you start the Lookup Wizard. To do so, follow these steps:
 * 1) Open your database in Access.
 * 2) On the Tools menu, click Options.
 * 3) Click the Tables/Queries tab.
 * 4) In the Default field type list, select Text, Number, or Yes/No.
 * 5) Click OK to close the Options dialog box.

