[RESOLVED] Help with select code

I am developing a prog to keep track of all my movies stored in various folders, external drives and dvd's

I have manged to include code to extract the information from the movie like resolution, aspect ratio and other info.

I have now added cmd button to play the movie from the program in Media Player and GOM Player based on the folder and movie name stored in a text box. D:\Movies\Thrillers\Edge of Darkness.avi

I now need to specify not to open the player when the text field is empty or not like a valid directory.

for instance if the text box = "" or not like :\
D:\Movies\Thrillers|Edge of Darkness.avi

I have tried

HTML Code:

---

If Location.Text = "" Or Location.Text not like "%:\%") Then
    msgbox "No location allocated to this Movie" _
            & vbCrLf & vbCrLf & "Please allocate correct location."
    Exit Sub
End If

---

With the not like "%:\%" I want the message to appear if :\ is not part of the text in the text box. I have tried various way without success.

Will appreciate if someone with more experience can help me out.

Code:

---

If Len(Location.Text) = 0 Or (InStr(Location.Text, ":\") = 0) Then

---

Thanks a ton. Nice to learn something new.