Image in report shows for empty field

[1974maiden]

I have the following code ...

SUB DETAIL_FORMAT
if isnull(me![txtImagePath]) then
me![iImage].picture = ""
else
me![iImage].picture = me![txtImagePath]
END SUB

this works fine (image is displayed) where the fieldname iImage has a path pointing to an image but when the field is empty or no path it still shows the previous image.

Any ideas out there ?

 

[tedmillerx]

man, i have this same problem. anybody know the answer?

 

[dhookom]

I always keep a small blank image file that I use if there is no real value.

Duane
MS Access MVP

 

[dhookom]

SUB DETAIL_FORMAT
if isnull(me![txtImagePath]) then
me![iImage].Visible = False
else
me![iImage].Visible = True
me![iImage].picture = me![txtImagePath]
END SUB


Duane
MS Access MVP