Prev: Snaking Report with Fixed Columns
Next: Want to print one record
From: Harold on 11 Mar 2010 09:32
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Dim ch As Object
Set ch = Reports![Report2]![OLEUnbound0]
With ch.Axes(xlValue)
.HasTitle = True
With .AxisTitle
.Caption = "Revenue (millions)"
.Font.Name = "bookman"
.Font.Size = 10
End With
End With
End Sub

"Harold" wrote:

> I have a report with a chart inserted. There is a texbox [Text Box 1] I would
> like to programattically on the format event of the report.
>
> Thanks
 | 
Pages: 1
Prev: Snaking Report with Fixed Columns
Next: Want to print one record