"The wizard is unable to create your form" error message in Microsoft Access occurs when a field name contains double-byte characters

Article translations Article translations
Article ID: 2467758 - View products that this article applies to.
Expand all | Collapse all

SYMPTOMS

In Microsoft Office Access 2007 or in Microsoft Access 2010, you receive the following error message: 
The wizard is unable to create your form.
This occurs when you try to create a form by using the Access Form Wizard, and one of the field names that you added in the wizard contains double-byte (2-byte) characters. For example, a field name contains the Japanese characters for a left bracket or a right bracket.

CAUSE

This is a known problem in Access 2007 and in Access 2010.

RESOLUTION

To resolve this problem, use one of the following methods.

Method 1

Omit the double-byte characters from the field name.

Method 2
  1. Create a query, and add the table that contains the double-byte characters to the query.
  2. Add the fields that contain only single-byte characters in their field names.
  3. Save the query.
  4. Select the query, and run the Access Form Wizard to build the form.
  5. After the wizard is finished, open the form in design view or in layout view.
  6. Click the Add Existing Fields icon.
  7. In the Field List, select the table that contains the fields that have the double-byte characters.
  8. Drag the desired fields to the form.

Method 3
  1. In the navigation pane, select the table that has the fields that contain the double-byte characters.
  2. Click the Create tab on the ribbon.
  3. On the ribbon, select Form.
All the fields, and this includes the fields that contain the double-byte characters, are added to the new form.

MORE INFORMATION

This problem does not occur in Microsoft Office Access 2003.

For more information about double-byte (2-byte) characters, visit the following Microsoft website:

Double-Byte Character Sets in Windows
http://msdn.microsoft.com/en-us/library/cc194788.aspx


Properties

Article ID: 2467758 - Last Review: December 21, 2010 - Revision: 1.0
APPLIES TO
  • Microsoft Office Access 2007
  • Microsoft Access 2010
Keywords: 
KB2467758

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com