Dynamic Chart title

  • Thread starter Thread starter hotplate
  • Start date Start date
H

hotplate

I made a graph and the title is:

Private Sub Graph1_Updated(Code As Integer)
Me!Graph1.ChartTitle.Text = [Forms]![frmReports]![Dept] & "-" &
[Forms]![frmReports]![Shift] & " Weekly Report"
End Sub

How would I start a new line in the title between "shift" and the words
"Weekly Report"?

James
 
Try place Chr(13) & Chr(10) between them
.... [Forms]![frmReports]![Shift] & Chr(13) & Chr(10) & " Weekly Report"
Not sure if this works for chart titles but give it a try.
 
Thanks for the help, that worked, I also found that
[Forms]![frmReports]![Shift] & vbCrLf & " Weekly Report"
worked too.

Duane said:
Try place Chr(13) & Chr(10) between them
... [Forms]![frmReports]![Shift] & Chr(13) & Chr(10) & " Weekly Report"
Not sure if this works for chart titles but give it a try.

--
Duane Hookom
MS Access MVP


hotplate said:
I made a graph and the title is:

Private Sub Graph1_Updated(Code As Integer)
Me!Graph1.ChartTitle.Text = [Forms]![frmReports]![Dept] & "-" &
[Forms]![frmReports]![Shift] & " Weekly Report"
End Sub

How would I start a new line in the title between "shift" and the words
"Weekly Report"?

James
Click to expand...
Click to expand...
 
Back
Top