Chart title

  • Thread starter Thread starter ladybug via AccessMonster.com
  • Start date Start date
L

ladybug via AccessMonster.com

I have a chart on a report. When the report is opened a query runs that
prompts the user for criteria. The user has to type in a program name. The
report data will reflect only that of this program. I want there to be a
text field on the chart (preferrably as the chart title) that automatically
inputs the program name as specified by the user. How do I do this?
 
I have a chart on a report. When the report is opened a query runs that
prompts the user for criteria. The user has to type in a program name. The
report data will reflect only that of this program. I want there to be a
text field on the chart (preferrably as the chart title) that automatically
inputs the program name as specified by the user. How do I do this?
Click to expand...

\
If a form is used to enter the parameter...
Code the Report section's Format event that the chart is placed in:

Me!OLEUnbound0.ChartTitle.Text = "The program name is " &
Forms!FormName!ProgramControl
Me!OleUnbound0.Refresh

The form must be open when the report is run.

If just a query parameter prompt is used:

Me!OLEUnbound0.ChartTitle.Text = "The program name is " & [Enter
Program Name]
Me!OLEUnbound0.Refresh

The text within the brackets must be identical to the bracketed
criteria text in the query.

Change OLEUnbound0 to whatever the control name is of your chart
control.
 
Back
Top