Hello all,

Is there anyone who knows how to check the availability of image in th
folder?

I need it on my userform, if there is no image belonging to the cod
that it is requested then it should give me the message of "No imag
available".

But when I change the code, the image should be visible.

Please have a look at my code below,

With Image1
.Picture=LoadPicture(PathName)
If Image1.Picture=vbNull Then Image1.Visible=False An
lblnoimage.visible=True

End With


Just for your imformation; lblnoimage="No Image available"
At first, the code numbers of images were Numeric, then I add a lette
at the end of each code, like before 45120 after 45120a.

I thought this would solve the problem. But I cannot make the
image go away once I entered the wrong code or the code which has n
image in the database...

Please help me out,




Thank yo

--
Message posted from http://www.ExcelForum.com