Connecting Tech Pros Worldwide Forums | Help | Site Map

key selection in combobox

Steve Claflin
Guest
 
Posts: n/a
#1: Nov 12 '05
Is there a way to have multiple keystrokes select the first matching
item in a combobox? For instance, in the Doe family members combobox,
typing jo would go to Jane on the j, then John on the o keystroke.


--
Steve
--
http://www.steveclaflin.com

PC Datasheet
Guest
 
Posts: n/a
#2: Nov 12 '05

re: key selection in combobox


Yes! Open your form in design view and select the combobox. Open properties and
look for the AutoExpand property. Set it to Yes.


--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
www.pcdatasheet.com


"Steve Claflin" <PimentoTR6@cs.compost> wrote in message
news:3F847DCC.B8F0AE9C@cs.compost...[color=blue]
> Is there a way to have multiple keystrokes select the first matching
> item in a combobox? For instance, in the Doe family members combobox,
> typing jo would go to Jane on the j, then John on the o keystroke.
>
>
> --
> Steve
> --
> http://www.steveclaflin.com[/color]


Steve Claflin
Guest
 
Posts: n/a
#3: Nov 12 '05

re: key selection in combobox


Actually , they were already set that way, must be the default. But I
had added code to correct an annoying "feature" that typing the first
letter and hitting Enter fired a Change event, but left the Value
property as it was on the previous selection. Which I had "fixed" with:

cbCompany.Value = cbCompany.ItemData(cbCompany.ListIndex)

except that takes over and ends selection after one keystroke. Moving
that line to After Update solves the problem (which I had been reluctant
to do, since I wasn't "updating" anything -- the box is unbound).

Thanks for the help!

PC Datasheet wrote:[color=blue]
>
> Yes! Open your form in design view and select the combobox. Open properties and
> look for the AutoExpand property. Set it to Yes.
>
> --
> PC Datasheet
> Your Resource For Help With Access, Excel And Word Applications
> www.pcdatasheet.com
>
> "Steve Claflin" <PimentoTR6@cs.compost> wrote in message
> news:3F847DCC.B8F0AE9C@cs.compost...[color=green]
> > Is there a way to have multiple keystrokes select the first matching
> > item in a combobox? For instance, in the Doe family members combobox,
> > typing jo would go to Jane on the j, then John on the o keystroke.
> >
> >
> > --
> > Steve
> > --
> > http://www.steveclaflin.com[/color][/color]


--
Steve
--
http://www.steveclaflin.com
Closed Thread