difference between CHART and Report?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am confused. In a "REPORT" I can create an unbound text box and set its
control source as "FOR MONTH OF" and it will prompt be to enter the text I
want. For example I would enter, "JANUARY 2007" and this would appear in the
report. However, when I try to do this in a "CHART" it does not work? It
does NOT prompt me to enter the text and it appears on the chart as "#Name?".
Please help. I just want to be able to prompt a persone to enter a month
and year that is to appear at the top of the chart.
 
I am confused. In a "REPORT" I can create an unbound text box and set its
control source as "FOR MONTH OF" and it will prompt be to enter the text I
want. For example I would enter, "JANUARY 2007" and this would appear in the
report. However, when I try to do this in a "CHART" it does not work? It
does NOT prompt me to enter the text and it appears on the chart as "#Name?".
Please help. I just want to be able to prompt a persone to enter a month
and year that is to appear at the top of the chart.
Click to expand...

To change the chart's title, you can use the following method.

Code the Report Header's Format event:

Me!OLEUnbound0.ChartTitle.Text = InputBox("What Name") & " for date "
& InputBox("What Date?")
Me!OLEUnbound0.Requery

where OLEUnbound0 is the name of the chart control on the report.
Your's may be named differently.

Note: I believe this answers your specific question. I would have done
this differently by getting the date from the query parameter that is
the record source for the chart, or better yet from a form used to
enter the name and date wanted as criteria for the chart.

Me!OLEUnbound0.ChartTitle.Text = forms!FormName!NameControl & " for
date " & forms!FormName!DateControl
Me!OLEUnbound0.Requery
 
Back
Top