Results 1 to 2 of 2
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    Alzano Lombardo, Italy
    Posts
    1,483
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Modifying a PivotChart title (2000)

    I'm trying to modify the title of the pivot chart in the subform contained in the startup form of the attached mdb but the code stops at the line
    Me!AMdati.ChartSpace.HasChartSpaceTitle = True
    with the message:
    Run-time error '438':
    Property or method not supported by the object.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 28 Times in 28 Posts

    Re: Modifying a PivotChart title (2000)

    You must refer to the Form object in the subform. And in the next line too.

    Private Sub Anno_AfterUpdate()
    With Me.AMdati.Form.ChartSpace
    .HasChartSpaceTitle = True
    .ChartSpaceTitle.Caption = "Here's Your Title " & Me.Anno
    End With
    End Sub

    Note for others reading this: although the subject mentions 2000, PivotCharts require Access 2002 or higher.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •