Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2012

    Unanswered: Multi-Record Report - Toggle visibility of image based on checkbox value

    I'm building a database for a real-estate project and for each home/lot I am displaying a whole bunch of info. I have a transparent background image - Image78, and I'm laying it over the house pic.

    What I want is for each record, that the Image78.visible=Was_Sold.value

    I set up:

    Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
    End Sub
    Private Sub Report_Current()
    Image78.Visible = Was_Sold
    End Sub
    This overlays the Image78 over all or no records depending on whether I click on a sold or unsold lot.

    Why is this affecting all or no records? I've been poking at this for hours now. Thanks to any responses in advance!

  2. #2
    Join Date
    Jan 2012
    I am having similar problems applying code to the current record. Keep an eye on my post and u might get an answer there.

  3. #3
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    the image control has various properties
    what is was_sold?
    is it boolean
    what happens if you step through the code after stettign a break point?

    my expectation is that the code should be in the reports on format detail event
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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