If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Combo box help
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 |
#3
|
|||
|
|||
Combo box help
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 |
#4
|
|||
|
|||
Combo box help
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 |
#5
|
|||
|
|||
Combo box help
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 |
Thread Tools | |
Display Modes | |
|
|