Please help with MS Graph 97

[Trevor watling]

Does anyone know how to refer to a drawing object in an
embedded chart (MS Graph 97) in VBA?

I have an Access 97 form with an embedded chart object.
Inside the chart, I have a text box called "Text Box 1"
which I added to the chart at design time.

I want to be able to use the Form_Current event to
programmatically alter the text displayed in this text box
based on certain information in the current record.

I can manipulate the title and axes, etc, but there does
not appear to be a way to access drawing objects in an
MSGraph.Chart.8 class in VBA.

I have searched the object browser and the Microsoft
website for an answer, but can't find any property or
method of the MSGraph.Chart.8 class that will allow me to
programmatically change the text displayed in this text
box while running the Access form.

Can anyone help me please.

Thanks,
Trevor

Additional info:
[I am aware that Excel chart objects have a Shapes
collection that you can use to get a reference to drawing
objects. I have tried to insert an Excel chart rather than
an MSGraph object into the form, but I keep getting an OLE
server is not registered error and I do not know what the
DLL is that is corrupted.]

 

[Cindy M -WordMVP-]

Hi Trevor,

Does anyone know how to refer to a drawing object in an
embedded chart (MS Graph 97) in VBA?

Basically - and unfortunately - you can't. A couple of us
have been around this block with each new version of
Office, and there are simply some things MS Graph doesn't
support in the VBA interface. Accessing any drawing objects
(even textboxes) isn't supported. Nor are color palettes.
If we need these things (Powerpoint and Word), we insert an
Excel chart object, instead.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update
Sep 30 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail

 

[Guest]

Thank you for your answer. Now I know for certain.

Trevor.