ACC: Graph Object Appears Dimmed or Blank in Form View (95913)

Microsoft Access 1.0

Microsoft Access 1.1

Microsoft Access 2.0

Microsoft Access for Windows 95 7.0

Microsoft Access 97

This article was previously published under Q95913

Moderate: Requires basic macro, coding, and interoperability skills.

SYMPTOMS

In Microsoft Access 7.0 and earlier, a Microsoft Graph object appears dimmed or grayed in Form view.

In Microsoft Access 97, a Microsoft Graph object appears as empty or blank in Form view.

CAUSE

This behavior occurs if the RowSource property of a Graph object is invalid.

RESOLUTION

To work around this behavior, use a valid setting in the RowSource property of the graph object.

STATUS

This behavior is by design.

MORE INFORMATION

Steps to Reproduce Behavior

Create a new form not based on any table or query.
On the Insert menu, click Object (or in versions 1.x and 2.0, click Insert Object on the Edit menu). In the Object Type box, select Microsoft Graph 97, (or Microsoft Graph 5.0 in version 7.0 or earlier), and then click OK.
Update the graph to Microsoft Access by closing Microsoft Graph on the File menu and clicking Exit and Return to Form <form name>. (In versions 1.x and 2.0, click Yes to update Microsoft Access.

Change the following properties of the graph object:

      Object Frame:
         Scaling: Scale (In versions 1.x and 2.0 only)
         RowSourceType: Value List
         RowSource: Title;AAA;H1;H2;H3;1;2;3
         ColumnCount: 3

Open the form in Form view. Note that the graph appears dimmed because the RowSource property only contains eight values while the ColumnCount is 3. To correct the graph, add another value to the RowSource property list.

REFERENCES

For more information about why graphs appear dimmed, type "Why does my graph appear dimmed?" in the Office Assistant, click Search, and then click to view "Troubleshoot Charts."

Modification Type:

Major

Last Reviewed:

5/9/2003

Keywords:

kbprb KB95913