OLE Bound Control

[Brian Keanie]

I have two OLEbound controls on a Tabbed subform. The properties list does
not allow "can shrink" Is there any way to tell this monster that I don't
want to have a great big blank space if in fact there is no data in the OLE
for a particular record?

Thanks and regards

[Stephen Lebans]

Test for existance of image data, if NULL set the OLE Frame control's
VISIBLE prop to NO.
*Air Code*
Me.NameOfYourOLEFrameControl.Visible =
(IsNull(Me.NameOfYourOLEFrameControl.Value))
--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"Brian Keanie" <bk******@sympatico.ca> wrote in message
news:Et********************@news20.bellglobal.com. ..

I have two OLEbound controls on a Tabbed subform. The properties list does not allow "can shrink" Is there any way to tell this monster that I don't want to have a great big blank space if in fact there is no data in the OLE for a particular record?

Thanks and regards

[Rog]

Surely that must be

Me.NameOfYourOLEFrameControl.Visible = NOT
(IsNull(Me.NameOfYourOLEFrameControl.Value))

?

[Stephen Lebans]

Surely you are correct. Surely as well I did indicate it was Air Code.
Thank you for the correction.
--

Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"Rog" <de********@state.gov> wrote in message
news:11**********************@o13g2000cwo.googlegr oups.com...

Surely that must be

Me.NameOfYourOLEFrameControl.Visible = NOT
(IsNull(Me.NameOfYourOLEFrameControl.Value))

?