 | |
moving to last name in Listbox issue
comp.databases.ms-access comp.databases.ms-access
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
moving to last name in Listbox issue -
04-09-2010
, 03:21 PM
#2
| |||
| |||
|
|
in a combobox as I type the last name the highlight moves down the list to the approperiate entry. in a listbox this does not happen, when I type the first character like 'h' the highlight moves to the first last name beginning with 'h'. If I then type the second character of the last name such as 'y' the highlight moves the the first last name beginning with 'y', not good.......... why doesn't it work the same as a combobox but more important, how do I make it work the same as a combobox??? |
developed the code for it's behavior did not write to that spec.
Greater minds than mine will probably chime in with the solution
to the second one. IIRC, writing functionally-similar code to
make a VB6 combo box work the same as an MS Access combo box
resulted in about three pages of code.
--
PeteCresswell
#3
| |||
| |||
|
|
Hi All, In access xp I have a form that has a listbox, normally I use combboxes but in this case I have to use a listbox. The listbox list lastname, firstname,email. Bound column is lastname and the rowsource is sorted by last name. in a combobox as I type the last name the highlight moves down the list to the approperiate entry. in a listbox this does not happen, when I type the first character like 'h' the highlight moves to the first last name beginning with 'h'. If I then type the second character of the last name such as 'y' the highlight moves the the first last name beginning with 'y', not good.......... why doesn't it work the same as a combobox but more important,, how do I make it work the same as a combobox??? thanks bobh. |
Because it wasn't designed to work like a combo box.
Question .. how do I make it work the same as a combo box? ...
Sorry but a List Box is a List Box and a Combo Box is a Combo
Box. The best you can do is to keep repeating the "h" and it will jump
to the next item that begins with the letter "h".
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
#4
| |||
| |||
|
|
In access xp I have a form that has a listbox, normally I use combboxes but in this case I have to use a listbox. The listbox list lastname, firstname,email. Bound column is lastname and the rowsource is sorted by last name. in a combobox as I type the last name the highlight moves down the list to the approperiate entry. in a listbox this does not happen, when I type the first character like 'h' the highlight moves to the first last name beginning with 'h'. If I then type the second character of the last name such as 'y' the highlight moves the the first last name beginning with 'y', not good.......... why doesn't it work the same as a combobox but more important, how do I make it work the same as a combobox??? |
1. if you're looking for lastname "Fenton", type F to go to the
first F, F again for the next, and F again and again until you get
to the match you want. Not as convenient as combo box autocomplete,
but not exactly terrible.
2. a dropped-down combo box looks an awful lot like a listbox. It
can't be multiselect, but what you're asking for wouldn't be useful
for multiselect, anyway. So, consider using a combo box and drop it
down when the user lands in it, and then you can have autocomplete.
--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
#5
| |||
| |||
|
|
Question .. why doesn't it work the same as a combo box ... Because it wasn't designed to work like a combo box. Question .. how do I make it work the same as a combo box? ... Sorry but a List Box is a List Box and a Combo Box is a Combo Box. The best you can do is to keep repeating the "h" and it will jump to the next item that begins with the letter "h". |
Surely you could combine the listbox with a textbox and filter the
listbox in the textbox's OnChange event. That's not the same as
AutoComplete, but it would make a large listbox easier to use.
--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
#6
| |||
| |||
|
|
fredg <fgutk... (AT) example (DOT) invalid> wrote innews:175rj52u2dvz.33tedgqo8ao1.dlg (AT) 40tude (DOT) net: Question .. why doesn't it work the same as a combo box ... * * *Because it wasn't designed to work like a combo box. Question .. how do I make it work the same as a combo box? ... * * *Sorry but a List Box is a List Box and a Combo Box is a Combo Box. The best you can do is to keep repeating the "h" and it will jump to the next item that begins with the letter "h". I agree with your answers, except for your "the best you can do..." Surely you could combine the listbox with a textbox and filter the listbox in the textbox's OnChange event. That's not the same as AutoComplete, but it would make a large listbox easier to use. -- David W. Fenton * * * * * * * * *http://www.dfenton.com/ usenet at dfenton dot com * *http://www.dfenton.com/DFA/ |
contents based on the text typed.
Br@dley
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.