Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Programming Charts on Reports! 1

Status
Not open for further replies.
zink421

zink421

Programmer
Aug 21, 2001
16
US
Hello,

I have a report with a chart on it. I would like to change the legend strings or anything about the chart through code? Any ideas on how to access the properties of the chart through code in a report would be great?

Thanks,
Jason
 
Sort by date Sort by votes
I have done this before by opening the report in design mode first (through VBA), saving the report and then either previewing the report or just printing it. It helps to set Echo to false during the design mode work that way the user does not see anything. Once in design mode you can access the chart object, as long as you have a reference its library in your References.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Teri Bridges
  • Locked
  • Question
Reports Combobox-List box
Replies
1
Views
366
dhookom
dhookom
JimStrand
  • Locked
  • Question
Expression Limit on Sum IIf In Method ? Used in Report Calculation
Replies
1
Views
450
dhookom
dhookom
caykamanj1966
  • Locked
  • Question
Open Report based on selection from a pull-down menu 1
Replies
12
Views
665
caykamanj1966
caykamanj1966
breezett93
  • Locked
  • Question
What should be multiple reports is becoming one report with multiple pages 1
Replies
13
Views
344
dhookom
dhookom
FancyPrairie
  • Locked
  • Question
How to Format a date on a report
Replies
1
Views
310
sxschech
sxschech

Part and Inventory Search

Sponsor

Back
Top