Ken Getz has authored another Visual How-to adapted from the Access Cookbook. This one’s about creating combo boxes that allow the user to specify a null,
Microsoft Office 2007 Key, or “not applicable” value. Here’s the overview: Sometimes Access developers must create applications that require users to specify a value from a long,
Office Professional Plus 2010, restricted list of data in a combo box. While that is a standard problem and has a standard solution,
Office 2010, it is a more difficult undertaking to include a <N/A> option in your combo box that users can select to specify a null value for a particular field. The solution uses a simple Union query and an unbound combo box where users cannot enter any invalid entries,
Microsoft Office 2007 Enterprise, just a provided value or a special string such as “<N/A>”. Check out the sample database and the video demo that walks you through the scenario. <div