There is a simple work around.
Create a text box. Set its locked property to yes and enabled to no.
Place it on the combo box so that only the drop down is visible.
Now set the background to transparent.
The user will now be able to select drop down but will be unable to type anything.
Phucon, try the properties/data/allow user input/no option to see if that does what you want.
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Wednesday, September 03, 2014 7:00 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Combo Box
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
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
Posted by: Rajiv <torajiv@gmail.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (19) |
Tidak ada komentar:
Posting Komentar