Text box

  • Thread starter Thread starter Rich Cooper
  • Start date Start date
R

Rich Cooper

Heres the siuation. I have a colum of names, and i have alittle form with
some label boxs and a text box. The text box displays the name. I want to
be able to use the text box as a search function aside from just displaying
a name. So in other words i have a list of names and a text box. I want
you to be able type the name and it to auto complete as you type the name.
So say you have a list of 3 names: cooper, rich; cooper steven; smith, joel;
in the text box i have typed "smi" and it auto completes to smith, joel.
Can this be done and if so how?
 
Hi Rich

Sure. All it takes is a little VBA coding. But try first a ComboBox, it
behaves like this on its own and you can pick from its list with keys or
mouse.

HTH. Best wishes Harald
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top