i have saw these examples but it does not meet my requirment please provide my some sample code

Naveed, after 152 posts I'm sure that you know how to post a proper question. Your question

How can we auto complete a textbox in VB 6 please help

is answered by my post above.

Maybe you should give me more information on exactly what you want before saying the code does not work for you.

What do you want to automate in your textbox?

Sorry
when i press 'a' then there should be a drop down list having all records strating from 'a'

Sorry if you mind exteamly sorry

No problem.:)

Question - Will the text box read from a database or normal text file. In other words, if you press "a", will it read from a database all records starting with a, all will it look for all words starting with a from a pre-defined text file?

Under your text box change event, open the database and read from it by using the following select statement -

SELECT YourFieldNameHere FROM YourTableNameHere WHERE YourFieldNameHere LIKE " & "'" & Textbox.Text & "%'", cn, adOpenStatic, adLockOptimistic

I am using this peace of code but still no luc please help

On Error Resume Next
rs1.MoveFirst
    Set rs1 = db.OpenRecordset("SELECT StudentName FROM Admission WHERE StudentName LIKE '" & txtsname & "%'")

Show me all the code you are using for reading the data, not just my peace of code. I'm sure the error lies in there somewhere.:)

This article has been dead for over six months. Start a new discussion instead.