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

  • Thread starter Thread starter No Go
  • Start date Start date
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
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

OLE Object and forms 1
Error when printing report 4
Acc 2007 and OLE Object Error 5
shrinking pictures to fit in OLE picture spots 1
starting OLE server 3
Report with a word doc that flows 1
OLE Server Error in Access 2003 1
Combo box size in report 2

Back
Top