ACC: Graph Object Appears Dimmed or Blank in Form View

• Microsoft Access versions 1.0, 1.1, 2.0, 7.0, 97

SYMPTOMS

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

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

1. Create a new form not based on any table or query.

2. 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.

3. 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.

4. 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
   
   

5. 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."