OLE Bound Object Again

[Brian Keanie]

Sorry to be so persistent but would really liek to get an answer to this.

If OLE object in a report is null, I can hide it with the visible property
but it leaves a great void blank space in my report before the next record
prints. Is there a way to close up the space?

[Bob Quintal]

"Brian Keanie" <bk******@sympatico.ca> wrote in
news:Wf*********************@news20.bellglobal.com :

Sorry to be so persistent but would really liek to get an
answer to this.

If OLE object in a report is null, I can hide it with the
visible property but it leaves a great void blank space in my
report before the next record prints. Is there a way to close
up the space?

the CanShrink property of the report sectionyour object is placed
on needs to be "Yes", You also need to ensure that there are no
other objects to the left or right of the object that will prevent
the report from shrinking.
--
Bob Quintal

PA is y I've altered my email address.

[Brian Keanie]

Bob ... Many thanks for response.
My OLE is in the details section of my report, there are no other controls
to the left or right and the "CanShrink" property for the details section is
set to yes but still no tightening up of the print output. I've tried making
the OLE both invisible and also height=0 but to no avail. Any further ideas?
Please.

"Bob Quintal" <rq******@sPAmpatico.ca> wrote in message
news:1111865563.e895b704fd6139b958ebd9ca690b627e@t eranews...

"Brian Keanie" <bk******@sympatico.ca> wrote in
news:Wf*********************@news20.bellglobal.com :

Sorry to be so persistent but would really liek to get an
answer to this.

If OLE object in a report is null, I can hide it with the
visible property but it leaves a great void blank space in my
report before the next record prints. Is there a way to close
up the space?

the CanShrink property of the report sectionyour object is placed
on needs to be "Yes", You also need to ensure that there are no
other objects to the left or right of the object that will prevent
the report from shrinking.
--
Bob Quintal

PA is y I've altered my email address.

[Stephen Lebans]

Answered in another NG.

--

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:Wf*********************@news20.bellglobal.com ...

Sorry to be so persistent but would really liek to get an answer to this.
If OLE object in a report is null, I can hide it with the visible property but it leaves a great void blank space in my report before the next record prints. Is there a way to close up the space?