Power Tip: Scale Access Chart objects at runtime

re: Power Tip: Scale Access Chart objects at runtime

Steve — Sun, 29 Aug 2010 15:56:48 GMT

Thanks for the original code, and for responding to comments. After experimenting, I see now that the form dimensions still need the final adjustment, even though it seems like you have already accommodated the dimensions.

re: Power Tip: Scale Access Chart objects at runtime

Peter De Baets — Fri, 27 Aug 2010 15:59:09 GMT

Steve, The form width and height are adjusted in case you are scaling down from a larger size. Without the adjustments, form scrollbars will appear. An alternative is to set the form ScrollBars property to "Neither", then you don't need to adjust the form width and height. Hope this helps, Peter De Baets

re: Power Tip: Scale Access Chart objects at runtime

Steve — Fri, 27 Aug 2010 14:58:19 GMT

Also, setting the form width and height at the end does not seem necessary, since you have already adjusted the control to match.

re: Power Tip: Scale Access Chart objects at runtime

Steve — Fri, 27 Aug 2010 14:53:02 GMT

It's worth noting that this code assumes .Left is zero initially. Also, if you have a header or footer, or if you display data above the chart, you may want to set the height as: .Height = Me.InsideHeight - .Top - Me.Section(acHeader).Height - Me.Section(acFooter).Height

re: Power Tip: Scale Access Chart objects at runtime

Roger Perkins — Fri, 27 Aug 2010 14:29:28 GMT

Hi Peter. I agree that the method in your original article gives a more polished result. Thanks for that - I'll keep it by me for when the need arises. Roger.

re: Power Tip: Scale Access Chart objects at runtime

Peter De Baets — Fri, 27 Aug 2010 13:33:47 GMT

Roger, Thanks for pointing out that you can get a similar result with Access 2007/2010 control anchors. I've done some testing as well by setting the Horizontal and Vertical control anchors to "Both". Here's what I noticed: - When using control anchors to scale the chart object, it scales smoothly beyond 9.7 inches, and the chart object always stays within the chart control.

- As you noticed, when the form window is sized smaller than the chart control, the chart is cropped. A work-around would be to make the chart control fairly small so it can be scaled up.

- Scaling up with this method scales up the size of the grid lines (and all the lines) in the chart. This may or may not be desirable.

- These lines of code are helpful in the form OnOpen event procedure when scaling with the control anchor method. With Me!OLEUnbound0 '<-- Your chart control name goes here '* Make sure that the chart control size '* mode is set to 'stretch' .SizeMode = acOLESizeStretch '* Make sure that chart fonts scale '* with the chart object .Object.ChartArea.AutoScaleFont = True

End With - This method works with Access 2007 and later versions. All the best, Peter De Baets

http://www.peterssoftware.com

re: Power Tip: Scale Access Chart objects at runtime

Peter De Baets — Fri, 27 Aug 2010 13:31:36 GMT

Srikanth, You can use: me!MyGraphControl.SeriesCollection(1).Interior.Color = vbRed ... to change the first series color to Red. Hope this helps, Peter De Baets

re: Power Tip: Scale Access Chart objects at runtime

Roger Perkins — Fri, 27 Aug 2010 05:51:45 GMT

I have just experimented using simply the anchoring facility in Access. It seems to work until the form gets smaller than the original size of the chart object, which is then cropped. I tried it in both a tabbed form, and a modal/popup form. Anchoring for the chart control was set Stretch down and accross.

re: Power Tip: Scale Access Chart objects at runtime

Srikanth — Fri, 27 Aug 2010 01:09:58 GMT

Thats a nice tip group.In the same way, I would like to know, that is there any option to color differently for a single bar (based on my own criteria) in this bar graph ?