Results 1 to 2 of 2
  1. #1
    Bronze Lounger
    Join Date
    Feb 2001
    Location
    Escondido, California, USA
    Posts
    1,458
    Thanks
    0
    Thanked 1 Time in 1 Post

    Inserting Pictures (2003)

    What procedure would you recommend for the following? I want to insert small pictures (clip art) into a report based on logical fields. That is, if field A is "yes" then insert a certain image, if the field is "no" then not. The same for several other logical fields with different images.

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Inserting Pictures (2003)

    I would include all of them in the report, then use the "on format" event of the detail section of the report to set the visible property of each picture to true or false, depending on the value of the relevant logical fields.

    Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
    Me.imageshell.Visible = Nz(Me.Shell_site, False)
    Me.Imagec4c.Visible = Nz(Me.C4C_site, False)
    Me.Imagetrans.Visible = Nz(Me.Translations, False)

    End Sub
    Regards
    John



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •