ACCESS FEED: RE: [MS_AccessPros] Combo Box

Rabu, 03 September 2014

RE: [MS_AccessPros] Combo Box

I mean data/limit to list/yes

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Wednesday, September 03, 2014 7:32 AM
To: 'MS_Access_Professionals@yahoogroups.com'
Subject: RE: [MS_AccessPros] Combo Box

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.