MICROSOFT ACCESS USER INTERFACE
Combine List Box and Checkbox Behavior
Use a subform to display and manipulate Yes/No data in a Checkbox control with something that looks like -- but really isn’t -- a list box.
Susan Sales Harkins is an independent consultant and the author of several articles and books on database technologies. Her most recent book is “Mastering Microsoft SQL Server 2005 Express,” with Mike Gunderloy, published by Sybex. Other collaborations with Mike Gunderloy are “Automating Microsoft Access 2003 with VBA,” “Upgrader’s Guide to Microsoft Office System 2003,” “ICDL Exam Cram 2,” and “Absolute Beginner's Guide to Microsoft Access 2003” all by Que. Currently, Susan volunteers as the Publications Director for Database Advisors at http://www.databaseadvisors.com. You can reach her at ssharkins at gmail.com.
Gustav Brock is a consultant and developer at Cactus Data ApS, independent software house specializing in accounting and time billing systems and custom database application. He has been working with Microsoft Access since version 1.0 and is a frequent contributor to the forum of developers hosted by Database Advisors at http://www.databaseadvisors.com.