Pictures in Reports

I have a report where I am trying to display pictures only when a check box
is selected. This part works fine. The problem I am having is formatting the
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/11245-pictures-in-reports.html
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11245
report so that there isn't space for a picture when the checkbox isn't
selected. Meaning, I have a list of equipment displaying, but only want a
picture when selected. However, when the checkbox isn't selected the space
for the picturte is still there. Any ideas?

Thanks in advance for any help.

*

 
Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!

You can use the format event to set the height of the picture to 0 (zero)
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11245
& Set the canshrink property to yes for the section
ie

Sub Detail_Format(....)
If Me.ChkBox = True Then
Me.PicPicture.Height=8000 ' Or Whatever
Else
Me.PicPicture.Height=0
End If


End Sub



"sponger02" wrote in message
news:4F18F7E2-5C68-465D-80BA-929541E7A12C@microsoft.com...
>I have a report where I am trying to display pictures only when a check box
> is selected. This part works fine. The problem I am having is formatting
> the
> report so that there isn't space for a picture when the checkbox isn't
> selected. Meaning, I have a list of equipment displaying, but only want a
> picture when selected. However, when the checkbox isn't selected the space
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11245
> for the picturte is still there. Any ideas?
>
> Thanks in advance for any help.

You can use the format event to set the height of the picture to 0 (zero)
& Set the canshrink property to yes for the section
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11245
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11245
ie

Sub Detail_Format(....)
If Me.ChkBox = True Then
Me.PicPicture.Height=8000 ' Or Whatever
Else
Me.PicPicture.Height=0
End If


End Sub



"sponger02" wrote in message
news:4F18F7E2-5C68-465D-80BA-929541E7A12C@microsoft.com...
>I have a report where I am trying to display pictures only when a check box
> is selected. This part works fine. The problem I am having is formatting
> the
> report so that there isn't space for a picture when the checkbox isn't
> selected. Meaning, I have a list of equipment displaying, but only want a
> picture when selected. However, when the checkbox isn't selected the space
> for the picturte is still there. Any ideas?
>
> Thanks in advance for any help.



--
----------------------------------------
I am using the free version of SPAMfighter for private users.
It has removed 3903 spam emails to date.
Paying users do not have this message in their emails.
Get the free SPAMfighter here: http://www.spamfighter.com/len