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 derfloh 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
Joined
Aug 21, 2001
Messages
16
Location
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 Question
Reports Combobox-List box
Replies
1
Views
761
dhookom
dhookom
JimStrand
  • Locked
  • Question Question
Expression Limit on Sum IIf In Method ? Used in Report Calculation
Replies
1
Views
1K
dhookom
dhookom
caykamanj1966
  • Locked
  • Question Question
Open Report based on selection from a pull-down menu
Replies
12
Views
2K
caykamanj1966
caykamanj1966
breezett93
  • Locked
  • Question Question
What should be multiple reports is becoming one report with multiple pages
Replies
13
Views
980
dhookom
dhookom
FancyPrairie
  • Locked
  • Question Question
How to Format a date on a report
Replies
1
Views
754
sxschech
sxschech

Part and Inventory Search

Sponsor

Back
Top