Re-Size/Re-Position BoundObjectFrame

[terri]

I am working with an application using the 2000 runtime.

I have a one page report which contains 9 Bound OLE objects. I want to hide
the fields that are empty (easy) and scale and re-position the visible fields
to use the maximum allowable space.

Trying to change the Top, Left, Height or Width properties in the Open Event
triggers a "Method ‘xxx’ of object _BoundObjectFrame failed" error - which is
trapped -- and the application continues (showing the fields in their
original size/position) seemingly without issue. However, when the app is
closed, an "abnormal program termination" from the Visual C++ Runtime
displays.

Short of having frames for every possible size/location combination and
setting the controlsources in the correct slots (which does work BTW), is
there a way to re-size and re-position this type of control?

Thanks!

 

[Stephen Lebans]

The ability of the OLE control to redraw itself properly, especially on an
Access report, is linked directly to the OLE Server app for the embedded
object.
Here is an example for Forms only, for Reports you will have to place your
code in the Format event of the section containing the control:
http://www.lebans.com/autosizeole.htm
--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

 

[terri]

Thanks! Got it going – and it was much easier than I had expected.

BTW – I am already using your convert to pdf, rotate text, and get
height/width functions.

YOU ARE THE BEST!