vg19

Hi,

I am making a Video Store Rental program for a project. Attached is my txt file with over 2000 movies and there status. What I want to do is havce a textbox and have the user able to enter a movie they want(even if they spell the title wrong or just enter one word) and display the results in order. However, Im not sure how to search the file to get this informaiton. Can anyone please guide me?

Thanks

lebb

If they just enter one word of the title, that's not too complicated since you can loop through the file using InStr() to see if the word they typed is contained in the title. Looking for misspellings, however, is going to be quite complex. If you happened to be using a database that supports it, you could possibly use the SQL SOUNDEX() function; otherwise you might be able to take advantage of the spelling suggestions provided by a spell checker such as that found in Word, if you could rely on the target systems having that.