Combo box help

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

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?

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


"Phil" wrote in message
.uk...
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

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

"Douglas J. Steele" wrote in message
...
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?

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


"Phil" wrote in message
.uk...
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

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)

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


"Phil" wrote in message
.uk...
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

"Douglas J. Steele" wrote in message
...
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?

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


"Phil" wrote in message
.uk...
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

Thanks for your help. The problem was that i had an input mask. i cleared it
and ,hey presto, alls fine
"Douglas J. Steele" wrote in message
...
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)

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


"Phil" wrote in message
.uk...
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

"Douglas J. Steele" wrote in message
...
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?

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


"Phil" wrote in message
.uk...
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