By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,122 Members | 927 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,122 IT Pros & Developers. It's quick & easy.

List box Help

P: n/a
Hi,
I'm useing Access 2000. I have an alphabetized list box in a form. Is there
an easy way to have the list box go to a certain letter in the list? Like if
I'm in the list box, and I type m, I will go down the list to words that
start with M.

Thanks
Nov 13 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
You can easily do this with a combobox. Just set the Autoexpand property to
Yes and the list will scroll to the first item in the list that begins with
the characters you already typed in.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"Enterprise" <so*****@microsoft.com> wrote in message
news:HN*******************@newsread1.news.pas.eart hlink.net...
Hi,
I'm useing Access 2000. I have an alphabetized list box in a form. Is there an easy way to have the list box go to a certain letter in the list? Like if I'm in the list box, and I type m, I will go down the list to words that
start with M.

Thanks

Nov 13 '05 #2

P: n/a
Can't do it with a combo box. I need it done specifically with a list box
unfortunately. The reason I need list box is because you don't have to click
that down arrow to see the list. In a list box its automatically there. I
guess I'll have to see if I can code this somehow.

Thanks

"PC Datasheet" <no****@nospam.spam> wrote in message
news:qD*****************@newsread2.news.atl.earthl ink.net...
You can easily do this with a combobox. Just set the Autoexpand property to Yes and the list will scroll to the first item in the list that begins with the characters you already typed in.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"Enterprise" <so*****@microsoft.com> wrote in message
news:HN*******************@newsread1.news.pas.eart hlink.net...
Hi,
I'm useing Access 2000. I have an alphabetized list box in a form. Is there
an easy way to have the list box go to a certain letter in the list?

Like if
I'm in the list box, and I type m, I will go down the list to words that
start with M.

Thanks


Nov 13 '05 #3

P: n/a
Put the following code in the Enter event of the combobox and when you tab
into the combobox or use the mouse to place the cursor in the textbox, the
list will automatically open:
Me!NameOfCombobox.DropDown

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"Enterprise" <so*****@microsoft.com> wrote in message
news:0O*******************@newsread1.news.pas.eart hlink.net...
Can't do it with a combo box. I need it done specifically with a list box
unfortunately. The reason I need list box is because you don't have to click that down arrow to see the list. In a list box its automatically there. I
guess I'll have to see if I can code this somehow.

Thanks

"PC Datasheet" <no****@nospam.spam> wrote in message
news:qD*****************@newsread2.news.atl.earthl ink.net...
You can easily do this with a combobox. Just set the Autoexpand property

to
Yes and the list will scroll to the first item in the list that begins

with
the characters you already typed in.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"Enterprise" <so*****@microsoft.com> wrote in message
news:HN*******************@newsread1.news.pas.eart hlink.net...
Hi,
I'm useing Access 2000. I have an alphabetized list box in a form. Is

there
an easy way to have the list box go to a certain letter in the list?

Like
if
I'm in the list box, and I type m, I will go down the list to words that start with M.

Thanks



Nov 13 '05 #4

P: n/a
Listboxes already behave as you described when the listbox has focus, so I'm
not sure what extra coding you would need to do.

"Enterprise" <so*****@microsoft.com> wrote in message
news:HN*******************@newsread1.news.pas.eart hlink.net...
Hi,
I'm useing Access 2000. I have an alphabetized list box in a form. Is there an easy way to have the list box go to a certain letter in the list? Like if I'm in the list box, and I type m, I will go down the list to words that
start with M.

Thanks

Nov 13 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.