Hello folks,
I have a report with an image control in its detail section. The report is based on a query (see image at bottom) that joins two tables of largely qualitative data on basic data as well as incidents for individual animals, so the detail section of the report is just info on one animal. Some of the records have photos associated with them and some do not, and I am wondering if it is possible to hide that photo control when there is no image? Here's the control:
I have tried this:
Code:
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If IsNull(Me.fraPhotos) = True Or Me.fraPhotos = "" Then
Me.fraPhotos.Visible = False
Me.lblPhotos.Visible = False
Else
Me.fraPhotos.Visible = True
Me.lblPhotos.Visible = True
End If
End Sub
But it does not work. thanks for any advice or info!
Here's the general idea of the query: