Pictures in Reports

#1 (**permalink**) 28-Jul-2006, 08:19 AM

I have a report where I am trying to display pictures only when a check box
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
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.

*

#2 (**permalink**) 28-Jul-2006, 08:19 AM

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
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.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11245

#3 (**permalink**) 28-Jul-2006, 08:19 AM

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
ie

Sub Detail_Format(....)
If Me.ChkBox = True Then
Me.PicPicture.Height=8000 ' Or Whatever
Else
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11245
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?
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11245
>
> 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