ACC: Unable to Add All Fields in Graph Form Wizard (1.x/2.0)

• Microsoft Access versions 1.0, 1.1, 2.0

SYMPTOMS

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

When you create a graph, you may receive the following error message if you try to include more than one date field in the graph:

You can select only one date field.

You can only select one non-numeric field if you want to use <number> fields for your chart.

STATUS

This behavior is by design.

MORE INFORMATION

When you are creating a chart with the Graph Form Wizard, the Add All (>>) button, even though it is displayed as a choice, will return an error message if your source table or query contains more than one date field. You will also receive an error message when using the Add All (>>) button if your source table or query contains more than one text field for a chart that has more than three fields.

Steps to Reproduce Behavior

1. Open the sample database NWIND.MDB.



2. Use Form Wizards to create a new form based on the Orders table.



3. When the Form Wizard asks "Which Access Wizard do you want?" select Graph. Choose the Next button.



4. When the Form Wizard asks "Which type of Graph do you want?" choose the Next button.



5. When the Form Wizard asks "Which fields contain the data you want to graph and use for labels?" select all the fields. To select all the fields, choose the Add All (>>) button.
   
   Note that when you choose the Next button, you will receive an error message indicating that only one date field can be in the graph.
   
   To receive the other error message, repeat steps 2-4, substituting the Customers table for the Orders table.

Keywords : kbtool IntpGrph
Version : 1.0 1.1 2.0
Platform : WINDOWS
Issue type : kbprb