listbox advance like a combobox

[Guest]

I created a listbox to search for a record and display that record. Now I
have 2000 names to scroll down through. In a combobox, if you type the letter
"T", the combobox advances to the names starting with letter "T". Not so in a
list box. But I don't want to use a combobox.

 

[Dirk Goldgar]

I created a listbox to search for a record and display that record.
Now I have 2000 names to scroll down through. In a combobox, if you
type the letter "T", the combobox advances to the names starting with
letter "T". Not so in a list box. But I don't want to use a
combobox.

A list box normally does advance to the first entry that begins with the
letter you typed. Are you sure it isn't doing that? There's a
difference, though, in what happens next. In a combo box, if you type
"TA", the list will advance to the first name beginning with those two
letters. A list box, however, only looks at the letter you most
recently typed, so typing "TA" positions the list at the first entry
beginning with A. You can make the list box cycle among the names
beginning with T by typing "T" repeatedly -- the first time finds the
first name starting with T, the next time finds the next name starting
with T, and so on.

 

[Guest]

In list box it does go to the first letter that you are typing
Its true about the second letter you are typing and beyond, that will work
only with combo.

If you have a second language on your computer, make sure that you are
working with the right language you have in the list box.

 

[Guest]

I looked at it again. Actually it is a combobox created through wizard /
record operations.........to look up and advance to a specific record. I
repeat it does not advance to the "Ps" if I type a "P"........could wizard
default a property setting to turn such action off?

 

[Dirk Goldgar]

I looked at it again. Actually it is a combobox created through
wizard / record operations.........to look up and advance to a
specific record. I repeat it does not advance to the "Ps" if I type
a "P"........could wizard default a property setting to turn such
action off?

Are you sure now that it's a combo box? Before you were saying it was a
list box, because you didn't want to use a combo box. I want to be sure
of what we're dealing with.

If it's a combo box, its Auto Expand property might be turned off.
Check the Data tab of the combo box's property sheet to see if it's set
to No. You would want it to be set to Yes.

 

[Guest]

Thanks, I did some more checking. it is a combo box, autoexpand is set to
YES, but I think the problem has to do with the bound column an dwhat I am
searching for:

the combobox pulls by a query

select firsttable.ID, secondtable.lname, etc
from secondtable inner join firsttable on secondtable.id = firsttable.id
order by lname, fname,date

The combobox DATA tab is set to BOUND COLUMN 1
column 1 displays as ID from the firsttable
column two displays as lname from the secondtable (innerjoin)

I am trying to advance by last name, typing S for Smith. If I type 106
instead, the combobox advances to id 106. but I'd rather search by last name
.. all the table have autorecords = id