Creating Combo Boxes in Access 2007 that Allow Users to Select N/A

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, or “not applicable” value.

Here’s the overview:

Sometimes Access developers must create applications that require users to specify a value from a long, restricted list of data in a combo box. While that is a standard problem and has a standard solution, 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, 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.

Office Blogs Comments

Comments: (1) Collapse

  • I often read this Blog to know news about MS Access and its future developments. Unfortunately on the last month I can see everywhere screenshots and descriptions of MS Access 2010 except here in this Blog. Besides I can see that MS Access 2010 Technical Preview can be downloaded as a torrent... Sam Caro.

Comments

Comments: (loading) Collapse