I have a form with a graph where users can enter values to adjust the min/max values for both axes. What I am doing works for the primary, but not the secondary axis.
This code works to change the primary axis but has no affect on the secondary axis
For testing purposes, I set all the min/max to static values and got the same result.
The odd thing is that this was working at one point and I'm 99% sure it stopped working after I did a "Compact & Repair" on the database.
Thanks in advance!
Code:
Private Sub UpdateAxis_Click()
Me.Scattergram.PrimaryValuesAxisRange = acAxisRangeFixed
Me.Scattergram.SecondaryValuesAxisRange = acAxisRangeFixed
Me.Scattergram.PrimaryValuesAxisMinimum = Me.MinValue
Me.Scattergram.PrimaryValuesAxisMaximum = Me.MaxValue
Me.Scattergram.SecondaryValuesAxisMinimum = Me.FirstDate
Me.Scattergram.SecondaryValuesAxisMaximum = Me.LastDate
Me.Scattergram.Requery
End Sub
This code works to change the primary axis but has no affect on the secondary axis
For testing purposes, I set all the min/max to static values and got the same result.
Code:
Private Sub UpdateAxis_Click()
Me.Scattergram.PrimaryValuesAxisRange = acAxisRangeFixed
Me.Scattergram.SecondaryValuesAxisRange = acAxisRangeFixed
Me.Scattergram.PrimaryValuesAxisMinimum = 0
Me.Scattergram.PrimaryValuesAxisMaximum = 40
Me.Scattergram.SecondaryValuesAxisMinimum = 42033
Me.Scattergram.SecondaryValuesAxisMaximum = 44127
Me.Scattergram.Requery
End Sub
The odd thing is that this was working at one point and I'm 99% sure it stopped working after I did a "Compact & Repair" on the database.
Thanks in advance!