var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Dynamic chart text - titles
I have a chart on a form which displays data selected by the user, as a result the y axis and chart title need to change in response to the variable selected by the user.
I can set the title to equal some text using:
Me.JGGraph.ChartTitle.Text = "My New Title"
but i cannot get it to use the text displayed in my Combo Box ([ComboParameter]) which is what is selected by the user.
Is there anyway to do this for the title and the Y axis(2)?
You can find a program in the following link, where the given code can be modified to include parameters to pass values for titles or Y-axis titles and assign them dynamically:
Working with Chart-Object in VBA
(Learn MS-Access Tips & Tricks)
Learn Advanced MS-Access Programming with sample VBA Code.
All responses are based on Access 2003/2007