Make Image field disappear if null value

[JudyK]

I have an image field on a report that keeps showing up even if the field value is null.

=IIf(IsNull([Image_tbl4mgr21]),"",[image_tbl4mgr21])

Any idea how to make the white space completely disappear when that image field is empty?

Judy

 

[JHB]

Try this by putting the following code in the format event for the reports detail section. The run the report by choosing "Print Preview".

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
  If IsNull(Me.[Image_tbl4mgr21]) Then
    Me.[Image_tbl4mgr21].Visible = False
  Else
    Me.[Image_tbl4mgr21].Visible = True
  End If
End Sub

 

[JudyK]

Thank you so much for providing help. I can't thank you enough. It worked flawlessly.

My understanding of code is limited at best and I really appreciate you taking the time to help me.

Kind regards,

JudyK

 

[JHB]

You're welcome, luck with you project.