Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2003
    Posts
    52

    Unanswered: charts type in Access 97

    i need to choose any kind of chart type at run time in Access 97, someone posted there a code for it but it works in Access 2002 and not in 97, how to do it??

    Dim ChartObj As Object

    Set ChartObj = Me.Chart1.Object.Application.Chart

    If (Some Test) = True Then
    ChartObj.ChartType = 76
    Else
    ChartObj.ChartType = 52
    End if
    this code works in 2002 and not in 97

  2. #2
    Join Date
    Aug 2002
    Location
    Northampton, England
    Posts
    266
    I think that the chart type numbers are different. They might be different in Access 97 and Access 2002 In Access 97 the chart type numers are

    Area is 1
    Bar is 2
    Column is 3
    3d Area is -4098
    3D Bar is -4099
    and 3D Column is-4100


    Try these values.

  3. #3
    Join Date
    Jan 2003
    Posts
    52
    only charttype = 1 and chart type=-4098 is working
    Originally posted by DJN
    I think that the chart type numbers are different. They might be different in Access 97 and Access 2002 In Access 97 the chart type numers are

    Area is 1
    Bar is 2
    Column is 3
    3d Area is -4098
    3D Bar is -4099
    and 3D Column is-4100


    Try these values.

Posting Permissions

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