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

 Last reviewed: May 28, 1997
Article ID: Q97511
The information in this article applies to:
  • 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 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.

Keywords : IntpGrph kbtool
Version : 1.0 1.1 2.0
Platform : WINDOWS
Hardware : X86
Issue type : kbprb
Resolution Type : Info_Provided

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: May 28, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.