Chart became 'bad' after acOLEClose

L

lwidjaya

I created a chart in a form so I can export it as jpg. This is the code:

Option Compare Database
Dim grpApp As Graph.Chart

Private Sub Command1_Click()

Set grpApp = Forms!Form5.Graph1.Object
grpApp.Export Filename:="C:\Test.jpg", FilterName:="JPEG"

Set grpApp = Nothing
Forms!Form5.Graph1.Action = acOLEClose

End Sub

When I re-opened the form, the chart format became bad. The fonts were big
and condensed and the bars looked short.
I re-created the chart and it was fine until I exported and re-opened the
form.
What did I do wrong?
Thanks in advance,
Lisa
 

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

Top