Phucon
Please ignore my earlier messages
Here is the code for doing this
Private Sub ComboBoxName_KeyDown(KeyCode As Integer, Shift As Integer) If KeyCode <> vbKeyTab And KeyCode <> vbKeyReturn Then KeyCode = 0 End Sub
On Wed, Sep 3, 2014 at 7:29 PM, saigonf7q5@yahoo.com [MS_Access_Professionals] <MS_Access_Professionals@yahoogroups.com> wrote:
Instead of selecting an item from the combo box, sometimes users like to type in what they want. When no match's found, they delete the text and sometimes press the enter key or click somewhere else… then an error number 94 Invalid use of Null occurs, and sometime that triggers some other type of errors.
In some other type of applications, like the web applications I've seen, users don't have the option to type the text into the combo box, they can only "click and select", that eliminates triggering the error… I am wondering if the Access combo box can be setup that way?
Phucon
__._,_.___
Posted by: Rajiv <torajiv@gmail.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (20) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar