Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms / October 2005

Tip: Looking for answers? Try searching our database.

List Box in a form

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Giorgos Louloudis - 14 Oct 2005 18:34 GMT
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 - 14 Oct 2005 19:09 GMT
> 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.

Signature

Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

Giorgos Louloudis - 17 Oct 2005 17:16 GMT
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 - 16 lines]
>maybe just knowing how the list box is supposed to work is enough for
>you.
Ripper - 14 Oct 2005 19:14 GMT
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!
Giorgos Louloudis - 17 Oct 2005 17:17 GMT
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
[quoted text clipped - 11 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!
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.