Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Pictures in Reports

Discussion in 'Information Technology' started by sponger02, Jul 28, 2006.

  1. sponger02

    sponger02
    Expand Collapse
    Guest

    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.
     
  2. Loading...

    Similar Threads Forum Date
    Sikh News In Pictures: Hundreds Of Youngsters Attend Sikh Summer Camp - Slough Express Breaking News Aug 13, 2016
    Events Collection Of Rare Historical Pictures From British India History of Sikhism Mar 10, 2015
    Opinion West Punjab : Information Pool and Pictures Punjab, Punjabi, Punjabiyat Nov 18, 2013
    Inspirational Pictures - Yes, Why? Inspirational Stories Oct 28, 2013
    Smartphone pictures pose privacy risks Information Technology Aug 14, 2013

  3. Pieter Wijnen

    Pieter Wijnen
    Expand Collapse
    Guest

    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
    Me.PicPicture.Height=0
    End If


    End Sub



    "sponger02" <sponger02@discussions.microsoft.com> 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.
     
  4. Pieter Wijnen

    Pieter Wijnen
    Expand Collapse
    Guest

    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
    Me.PicPicture.Height=0
    End If


    End Sub



    "sponger02" <sponger02@discussions.microsoft.com> 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
     

Share This Page