Combo box help

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Phil - 28 Sep 2006 21:27 GMT

I have a combo box on a form in which i enter information that occasionally
repeats. A query i have lists the information have entered previously. When
i enter the first letter for a new entry the combo box automatically
displays the first entry in the list with that particular letter and the
cursor moves to the end of the box. What i need it to do is allow me to
enter a 2nd and possibly a 3rd letter to find the match, i.e

the list contains
FAWLEY
FLEETWOOD
FRANKLEY
FRODSHAM

if i wantered to re-enter FRODSHAM in the field on pressing "F" Fawley is
displayed and i have to delete letters and manualy enter FRODSHAM.
What i need is after entering F it lists FAWLEY but allows me to enter the
2nd letter "R" thus showing FRANKLEY then allows me to enter "O" which would
then show FRODSHAM.

I hope you can understand the above.

tia

Reply to this Message

Douglas J. Steele - 28 Sep 2006 21:42 GMT

What you're describing is the default behaviour for combo boxes. While
FAWLEY will be displayed when you press the letter F, it shouldn't be
necessary to delete any letters from it: pressing the letter R should cause
FRANKLEY to replace FAWLEY, and subsequently pressing the letter O should
cause FORDSHAM to appear.

Is that different than what you're seeing?

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

>I have a combo box on a form in which i enter information that occasionally
>repeats. A query i have lists the information have entered previously. When
[quoted text clipped - 18 lines]
>
> tia

Reply to this Message

Phil - 28 Sep 2006 22:19 GMT

Yes, when FAWLEY appears the cursor moves to the end and any additional
typing is added to FAWLEY. So when looking for FRODSHAM i get FAWLEYR when
doing what you say

> What you're describing is the default behaviour for combo boxes. While
> FAWLEY will be displayed when you press the letter F, it shouldn't be
[quoted text clipped - 26 lines]
>>
>> tia

Reply to this Message

Douglas J. Steele - 29 Sep 2006 12:18 GMT

That's definitely not standard behaviour. Is there perhaps code in one of
the events for the combo box that is doing something unusual?

What version of Access? What are the Limit To List and Auto Expand
properties set to? (although they shouldn't cause the behaviour you're
describing)

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> Yes, when FAWLEY appears the cursor moves to the end and any additional
> typing is added to FAWLEY. So when looking for FRODSHAM i get FAWLEYR when
[quoted text clipped - 31 lines]
>>>
>>> tia

Reply to this Message

Phil - 29 Sep 2006 18:11 GMT

Thanks for your help. The problem was that i had an input mask. i cleared it
and ,hey presto, alls fine

> That's definitely not standard behaviour. Is there perhaps code in one of
> the events for the combo box that is doing something unusual?
[quoted text clipped - 38 lines]
>>>>
>>>> tia

Reply to this Message