 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / December 2007Combo Box - Limit to List
Hello, I have a combo box that has a list derived from a query. I want the user to only select data in the combo box and I have set the limit to list property to yes but users can still type in anything they want. The error message does display stating that it doesn't match the value in the list but I want to prevent the user from typing in anything at all other than those in the list. Can anyone help? I don't want to use a list box. Martin Can I ask why? Cause regardless if you limit to the list they can't leave that combobox until there is something that is in the list. > Hello, > [quoted text clipped - 10 lines] > > Martin I find that prohibiting typing in comboboxes makes a cleaner application where there are only a few choices to be made. When the user clicks on the combo, the list drops and he makes the choice. > Can I ask why? > [quoted text clipped - 19 lines] >> >> Martin > I find that prohibiting typing in comboboxes makes a cleaner application > where there are only a few choices to be made. When the user clicks on the [quoted text clipped - 25 lines] > > - Show quoted text - However, stopping the ability to type also stops the auto complete functionality. Ron Correct, but for my purpose it doesn't matter, becuase the mouse is used to select. >> I find that prohibiting typing in comboboxes makes a cleaner application >> where there are only a few choices to be made. When the user clicks on [quoted text clipped - 34 lines] > > Ron > Correct, but for my purpose it doesn't matter, becuase the mouse > is used to select. You are the only user of the database? Or are you one of those arrogant coders who insist that their way is correct and everybody who has a different way is an id10t? Use the combobox's On Key Press event to capture all keystrokes and discard them, possibly except for the enter key and or escape key. Q > "Ron2006" <ronnemec@hotmail.com> wrote in message > news:ab3686f3-1a4d-42f6-a30b-f516c678276c@d4g2000prg.googlegroups.c [quoted text clipped - 42 lines] >> >> Ron  SignatureBob Quintal PA is y I've altered my email address. -- Posted via a free Usenet account from http://www.teranews.com Bob, You misunderstood me. I was just answering Ron. I don't think there are many times to use this method, but if there are only a few, static choices, it can work well. If circumstances changed and the list increased then the method could easily be changed. Any methodolgy would depend on the user and the usage. God Bless, Mark >> Correct, but for my purpose it doesn't matter, becuase the mouse >> is used to select. [quoted text clipped - 55 lines] >>> >>> Ron > Bob, > [quoted text clipped - 7 lines] > > Mark My apologies. Ron's the one that needs to answer the questions (to himself if not to me) before he alienates a lot of users. >>> Correct, but for my purpose it doesn't matter, becuase the mouse >>> is used to select. [quoted text clipped - 58 lines] >>>> >>>> Ron SignatureBob Quintal PA is y I've altered my email address. -- Posted via a free Usenet account from http://www.teranews.com > > Bob, > [quoted text clipped - 91 lines] > > - Show quoted text - Ron? I just said it disables the autocomplete. Ron Ron2006 <ronnemec@hotmail.com> wrote in news:d3771333-63f6-4d7c-9482- 36bcc686f15e@d21g2000prf.googlegroups.co m: >> > Bob, >> [quoted text clipped - 10 lines] >> My apologies. Ron's the one that needs to answer the questions >> (to himself if not to me) before he alienates a lot of users. > Ron? > > I just said it disables the autocomplete. > > Ron Sorry Ron, I mistook you for the Original Poster. The OP is the one that needs to abnswer the question. Quoting seems to have mangled who said what. SignatureBob Quintal PA is y I've altered my email address. -- Posted via a free Usenet account from http://www.teranews.com Use the NotInList event for your combo: Private Sub MyCombo_NotInList(NewData As String, Response As Integer) MsgBox "You Must Select From the List" Response = acDataErrContinue Me.MyCombo.Undo End Sub SignatureDave Hargis, Microsoft Access MVP > Hello, > [quoted text clipped - 10 lines] > > Martin In the KeyDown event type this: KeyCode = 0 That will prevent typing anything at all into the combobox. God Bless, Mark A. Sam > Hello, > [quoted text clipped - 13 lines] > > Martin Thank you all for your responses, most helpful. In particular, thank you Mark A. Sam, just what was needed. Martin > In the KeyDown event type this: > [quoted text clipped - 23 lines] > > > > Martin > In the KeyDown event type this: > > KeyCode = 0 > > That will prevent typing anything at all into the combobox. It will also prevent the user from tabbing out of the combo box. It would probably be better to exclude the Tab and Enter keys from that blanket prohibiton on typing. SignatureDirk Goldgar, MS Access MVP www.datagnostics.com (please reply to the newsgroup) Dirk, Sorry, I am not that advanced. Can you expand on that. I have just tested the Keycode method and it does what I need expect as you say does not allow the tab button to work. Martin > > In the KeyDown event type this: > > [quoted text clipped - 5 lines] > probably be better to exclude the Tab and Enter keys from that blanket > prohibiton on typing. Dick, That's true, but can be accounted for. If KeyCode <> 9 Then 'Tab key pressed KeyCode = 0 End If God Bless, Mark >> In the KeyDown event type this: >> [quoted text clipped - 5 lines] > probably be better to exclude the Tab and Enter keys from that blanket > prohibiton on typing. Genius! > Dick, > [quoted text clipped - 17 lines] > > probably be better to exclude the Tab and Enter keys from that blanket > > prohibiton on typing. > Dick, Dirk > That's true, but can be accounted for. > > If KeyCode <> 9 Then 'Tab key pressed > KeyCode = 0 > End If Exactly. Though you probably want to allow 13 as well: Select Case KeyCode Case 9, 13 ' Allow these Case Else ' Ignore all other keys. KeyCode = 0 End Select SignatureDirk Goldgar, MS Access MVP www.datagnostics.com (please reply to the newsgroup) |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.