Needing to change the chart heading 2

[lakefun]

One of my reports contains a chart. And based on the data from the source query, the chart heading will need to change each and every time it runs. Can I modify this field with my VB code? Any help/ideas would be appreciated!

 

[DougP]

I think Maybe
If you create a Text box that gets its information from a "function" it will work

open Modules TAB

Add this
Function GetInfo()
GetInfo = something ' this needs to be a Textbox on a form or something

End Function

DougP, MCP

Visit my WEB site

http://www.barcodeone.com

to see how Bar-codes can help you be more productive

 

[lakefun]

The chart generates its own chart heading (it was done with the wizard) so I don't need to set up another one - I just need to modify the one on the chart. Is this possible?

 

[JoeMiller]

Delete the heading that the chart puts in their automatically. Place your chart in the report, now place an unbound textbox that goes from one side of the chart to the other where the title of the chart would normally be. Make the text in the textbox centered and manipulate the textbox in code to show your title. The charts are very difficult to manipulate through code and fairly undocumented so this would be a much easier battle to win.

HTH Joe Miller
joe.miller@flotech.net