Show an OLE control in a report only if it has data.

N

No Go

I have been using "Can shrink" on text boxes in a report so that only those
with data can be seen and thus eliminating blank pages.
The problem is I also have an OLE control and it doesn't seem to have the
ability to "Can shrink" resulting in large blank sections in a report when
it does not have data.
Making it invisible still leaves a blank area in the report. How do I get
the next text box to print in the OLE's place when there is no data in the
OLE?
Cheers
John
 
S

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