Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

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


View products that this article applies to.

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.

↑ Back to the top


Cause

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

↑ Back to the top


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.

↑ Back to the top


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


↑ Back to the top


Keywords: kb

↑ Back to the top

Article Info
Article ID : 2467758
Revision : 3
Created on : 8/20/2020
Published on : 8/20/2020
Exists online : False
Views : 244