returning part of text search result

[Tech]

hi there. working on a project of my own.

i have a main form/table with all information

made a query that searches for tracks

made a form based on this query

made another form, with a text box and a button, so when u type in the name of the track to search for, it goes and searches it.

all is great

but, I am wondering:


1) how do I make the search NOT CASE SENSITIVE?
2) how can I make the search so that, it takes the first few letters of the search textbox and find all records matching that?

for example:


in the actual table, there maybe a track named Urban Train (Suburban Train)

but, someone may search for Urban Train - it don't show it....so i need to somehow tell it to take the first few letters of the text and do the search.

how can I do this?

thank-you in advanced

 

[dcx693]

Try taking some ideas from this thread .

Regarding case sensitive searches, I'm not sure on this point, but I thought Access usually did case-insensitive searches and that the hard thing was getting Access to do case-sensitive search.