ACC: Microsoft Graph Changes May Not Be Retained

ID: Q97774


The information in this article applies to:


SUMMARY

Advanced: Requires expert coding, interoperability, and multiuser skills.

When you create a graph on a form or report and later make some changes to the formatting or to the data itself within Microsoft Graph, these changes may not appear in the form or report.

This article discusses the different sources of information that Graph normally uses and which sources take precedence over others in the hierarchy of graph changes.


MORE INFORMATION

There are several sources of information for a graph: the Microsoft Graph application, the contents of the graph object's RowSource property, and the data in the underlying table or query.

Microsoft Access regenerates the graph each time you print or preview the graph, or switch to Form view. When Microsoft Access regenerates the graph, it reads the SQL statement in the object's RowSource property. The name of the graph and the data to be graphed are obtained from this SQL statement. Microsoft Access obtains the format of the data from the table or query that is the source of the graph's SQL statement.

The precedence for changes is determined as follows:


REFERENCES

For more information about using graphs in Access, search the Help Index for "graphs."

Additional query words: chart


Keywords          : kbtool IntpGrph 
Version           : 1.0 1.1 2.0 7.0 97
Platform          : WINDOWS 
Issue type        : kbinfo 

Last Reviewed: March 23, 1999