I would like to copy an MSGraph chart from one Access form to an image control on another form.
I can copy the chart with:
Forms.myform.mygraph.chartarea.copy
If I paste the clipboard contents into MS Word, the chart looks just like the original so I know the copy operation worked.
When I try to "paste" into the gdviewer object:
object.gdviewer.DisplayFromClipboardData
the graph appears but a portion of the bottom and right side are cut off. This occurs no matter how I adjust the relative size of the graph and image controls, zoom settings, skip image resolution property, etc
I assume the problem occurs because I am copying a graph object rather than an image. If I copy the graph as above, then use "PASTE SPECIAL - picture(windows metafile)" to insert it into a MS Word document as an image, THEN copy that image and FINALLY fill the gdviwer control from the clipboard, everything looks perfect. However, that is obviouly very tedious and I don't want to have to open MS Word.
Any help would be greatly appreciated!
