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


The information in this article applies to:

  • Microsoft Access 1.0
  • Microsoft Access 1.1
  • Microsoft Access 2.0
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 <number> fields for your chart.

where <number> 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 "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.
Modification Type:MajorLast Reviewed:5/9/2003
Keywords:kbprb KB97511
©2002 Microsoft Corporation. All rights reserved.