Combo box help

P

Phil

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
 
D

Douglas J. Steele

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?
 
P

Phil

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
 
D

Douglas J. Steele

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)
 
P

Phil

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