Changing Colors of a chart based on Current record for a report.

[Allison3]

I have a report that displays one page per record with a graph of the records "group" and the record's data. I want to change the color of the bar on the chart for the current record to highlight it. I am using Access 2002. I'm sure this can be done I'm just not sure where to start.
Thanks

 

[dhookom]

I am copying a post from a fellow Access MVP:

I would recommend adding the Microsoft Graphs Library into the References of your database and then use the ObjectBrowser to browse through the different objects you can manipulate.

John Viescas' "Building Microsoft Access Application" (Microsoft Press) has a fair bit of sample codes to manipulate charts (pgs 311-315). Stephen Forte (et al)'s Microsoft Access 2000 Development (SAMS) also has a fair bit of Excel / Chart automation sample codes also.

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]

 

[Allison3]

Thanks Duane. I'd already loaded the Library so I'll look for those books to see if they can help me get started with the coding.

Allison