picture in report size and placement

[Mohammad Saeb]

Hi all
i have a situation, a database where SOME of records have link to photos.
Now in report a space is always reserved for photos even that the record does
not content one. How can I make the space of the photo be illiminated if the
record does not contain one???

 

[Zac Woodall [MSFT]]

I believe you should be able to set the Image control's visibility property
in the OnFormat event for the section in which it appears.

 

[Larry Linson]

"Mohammad Saeb" wrote

i have a situation, a database where SOME of
records have link to photos. Now in report a
space is always reserved for photos even that
the record does not content one. How can I
make the space of the photo be illiminated if
the record does not contain one???

The Image Frame and OLE Frames do not have the Can Grow / Can Shrink
properties that allow you to eliminate the space, as do some other controls
(e.g., Text Boxes). And, of course, simply setting the Visible property to
False does not eliminate the space; it just prevents seeing the Frame.

The Subreport Control does have a CanGrow/CanShrink property, so perhaps you
could put the Control for displaying your images in a Subreport Control,
then let that "shrink away" if there is no picture.

Larry Linson
Microsoft Access MVP