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

sydcomebak · #1 (**permalink**) 01-31-12, 23:41

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:

Code:

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!

oMADMANo · #2 (**permalink**) 02-01-12, 01:51

I am having similar problems applying code to the current record. Keep an eye on my post how to run code in Current record ? and u might get an answer there.

healdem · #3 (**permalink**) 02-01-12, 04:47

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

Internet Services

Web Development

Digital Marketing

Consumer Tech