Graph properties by visual basic

[kobooky]

I want to define the properties of a graph in a report by the visual basic code of the report.
lets say that the graph object is called graph1
the properties are:
line colors, line widths etc...
I could not find the syntax that specifies these properties.
Can someone help me?

 

[dhookom]

I generally create a similar graph in Excel. I then set the macro record on and change the properties that I would like to change in my Access graph. You can then find the Excel VBA code and use it in the Access report with a few modifications (trial and error).

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[kobooky]

If I’m not mistaken the excel solution is not good for me.
My application generates a big amount of graphs from the database, each one in a separate page.
I’m not sure how the excel will handle this.
I think I need to do everything within the access.
My report is all ready doing all this but I want to improve its flexibility and for this reason I want to write a code with the chart properties as I’ve described.

 

[dhookom]

I didn't suggest that you create your "finished product" in Excel. You asked how to write code to modify a graph in Access. I told you the method that I use. The code from Excel can be copied into Access and modified.

Access allows you to use Link Master/Child to create many similar graphs in a single report by defining only one graph.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[GingerR]

kobooky--what are you attempting to do? I've made a ton of complex charts over the years without using hardly any "code".

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244