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
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