Show/Hide Bound Picture Control

[Guest]

I'm creating a report that will include a page with a map to a location
(bound object control). The maps will be bitmap pictures, pdf files, or word
documents.

Not all locations will have a map. Is there a way that I can avoid printing
a blank page if there is no map to print? Obviously, there is no simple 'Can
Shrink' property, so what other methods could I use?

I'm okay with using code, but if there is an easier method (perhaps
involving properties, or some kind of function), that would be great.

Thanks for your help,
KB

 

[Guest]

You can check to see if the string value of the bound object control is empty
or null and if it is then set the .Visible property to False. If you can put
the control in it's own seperate section of the report you can hide the
entire section so it won't print a big blank space in the middle of the
report.

HTH
scruffy