Microsoft KB Archive/97511

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

Article ID: 97511

Article Last Modified on 5/9/2003

-

APPLIES TO


 * Microsoft Access 1.0 Standard Edition
 * Microsoft Access 1.1 Standard Edition
 * Microsoft Access 2.0 Standard Edition

-



This article was previously published under Q97511



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



SYMPTOMS
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 may receive the following error message if you try to include more than three fields in the graph and more than one of those fields is a text field

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

where is the number of fields that you selected.



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 &quot;Which Access Wizard do you want?&quot; select Graph. Choose the Next button.
 * 4) When the Form Wizard asks &quot;Which type of Graph do you want?&quot; choose the Next button.
 * 5) When the Form Wizard asks &quot;Which fields contain the data you want to graph and use for labels?&quot; 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: kbprb KB97511

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.