Image File Errors - Trapping them with VBA

[kevin.philips]

Hi,

I'm struggling on this one and hope you can help...!

I have a form that contains a ListView and an Image control. I have the image control changing its LoadPicture property depending on what has been clicked in the ListView, now this works beautifully when the file exists but generates a path not found error when it doesn't, is there an easier way other than invoking a filesystem search to see if the file is available prior to setting the LoadPicture property...?

Best Regards

kevin

 

[Norie]

kevin

You can use Dir to see if a file exists.

If Dir("C:\MyImage.jpg")<>"" Then
   MsgBox "File exists."
Else
   MsgBox "File doesn't exist."
End If