What VBA code displays data point details when you click on the point in a chart?

[tmarynell]

I have created an SPC chart in Access. I need specific details of each data point wihtin the line graph to display when you hover over or double-click on the specific data point. It should include the data point value and which test was failed if out of spec. The data resides in a table. I am looking for the VBA code that will perform this task.
Thanks.

[Stewart Ross]

I'm not aware of any event you could use which would allow you to retrieve datapoint values on mouseover. Access has an On MouseMove event, but I doubt that it will be useful to you without using Windows API functions to determine exactly what datapoint the mouse is hovering over.

Perhaps other contibutors know better than I, but my immediate reaction is to say that Access itself cannot do what you ask as there are no datapoint mouseover events which you can tap into.

-Stewart

[tmarynell]

Stewart,
I tried using the MouseMove event, but as you indicated I could not display the data for a specific data point. I'm still hoping for a solution.
Thanks for your help,
Tianna