alter chart properties based on info in form

D

Dave

In access I am trying to go through a series of charts which are embedded in
a form. With the selection of a new record in the form, new data is shown in
the chart. This works. However the minimum value seems set at 0 in all of the
forms. I would like to set a variable for each record in the form for the
minimum x axis value. Then when I activate the next page of the form, have it
set the minimum value to my variable. I can do this in Excel with the script:

ActiveWindow.Visible = False
Windows("test file.xls").Activate
ActiveSheet.ChartObjects("Chart 1").Activate
ActiveChart.ChartArea.Select
ActiveChart.Axes(xlValue).Select
With ActiveChart.Axes(xlValue)
.MinimumScale = 0.031
.MaximumScaleIsAuto = True
End With
ActiveWindow.Visible = False
Windows("test file.xls").Activate

However, I am having a hard time getting this to work in access. Is there an
equivalent script for Access that will adjust the chart properties when the
"on current" set of Code runs?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

access chart - dynamic changes 0
Macro to Activate a Macro 6
Excel inconsistency 4
secondary Y axis 1
Creating a Chart on form from selected data in query. 0
Code to Create Chart 0
help on vba macro to put multiple charts on multiple worksheets based on table in each worksheet 0
Changing a horizontal axis crosses value using VBA 5

Top