List Box in a form

[Giorgos Louloudis via AccessMonster.com]

Hello there!i have created a list box in a form where all my clients names
appear.When i click in the list box and i type the first letter the list box
works as an anchor leading me to the first name with that letter.I can not
figure out how this can work for more letters.Say for example that i have a
client George and Graham and Evan.I want to click in the list box and if i
type the letters ge i want George to be selected.What happens at the moment
is that when i press g it goes to the first g name but at the time i press e
it goes to the first name that starts with e. please help me if u can!

 

[Dirk Goldgar]

Hello there!i have created a list box in a form where all my clients
names appear.When i click in the list box and i type the first letter
the list box works as an anchor leading me to the first name with
that letter.I can not figure out how this can work for more
letters.Say for example that i have a client George and Graham and
Evan.I want to click in the list box and if i type the letters ge i
want George to be selected.What happens at the moment is that when i
press g it goes to the first g name but at the time i press e it goes
to the first name that starts with e. please help me if u can!

Unfortunately, the list box doesn't have built-in auto-expand or
"auto-search" capabilities the way a combo box does. In a list box
(unless you write some special code), to find the next item that starts
with "G", you just press "G" again. You can press the same letter over
and over to cycle through all the list items that start with that
letter -- it will go back to the first "G" in the list when you run out
of "G"s.

It's possible, I think, to write code to make the list box act the way a
combo box does. I thought I had an example of that lying around in my
"test and demo" database, but I can't find it at the moment. Let me
know if you want me to try to find that -- or write it over again. But
maybe just knowing how the list box is supposed to work is enough for
you.

 

[Guest]

Sounds like you could use a combo box in place of the list box. With a combo
box you can type in the name and it will appear and it will continue no
matter how many characters in the name you type.

Worked great for me. I started with the list box, but went to the combo box
in all my applications.

Hope it helps,
Rip

 

[Giorgos Louloudis via AccessMonster.com]

Thanks for your help Dirk.It helped me a lot!

Hello there!i have created a list box in a form where all my clients
names appear.When i click in the list box and i type the first letter

[quoted text clipped - 5 lines]

press g it goes to the first g name but at the time i press e it goes
to the first name that starts with e. please help me if u can!

Unfortunately, the list box doesn't have built-in auto-expand or
"auto-search" capabilities the way a combo box does. In a list box
(unless you write some special code), to find the next item that starts
with "G", you just press "G" again. You can press the same letter over
and over to cycle through all the list items that start with that
letter -- it will go back to the first "G" in the list when you run out
of "G"s.

It's possible, I think, to write code to make the list box act the way a
combo box does. I thought I had an example of that lying around in my
"test and demo" database, but I can't find it at the moment. Let me
know if you want me to try to find that -- or write it over again. But
maybe just knowing how the list box is supposed to work is enough for
you.

 

[Giorgos Louloudis via AccessMonster.com]

I know that this can be done with a combo also but i want to see the clients
i have and be able to select anyone and see his orders..Thanks a lot for the
help!!

Sounds like you could use a combo box in place of the list box. With a combo
box you can type in the name and it will appear and it will continue no
matter how many characters in the name you type.

Worked great for me. I started with the list box, but went to the combo box
in all my applications.

Hope it helps,
Rip

Hello there!i have created a list box in a form where all my clients names
appear.When i click in the list box and i type the first letter the list box

[quoted text clipped - 4 lines]

is that when i press g it goes to the first g name but at the time i press e
it goes to the first name that starts with e. please help me if u can!