Home  Fees/Services  Access Templates  Tutorials  Tutorial Downloads  Articles  Search  Contact  Privacy  Links

True/False Combo Box
Access Combo Box


Updated On 5/22/2017 8:51:00 PM

Combo Box Tutorial






Combo Box Tutorials
Fill Form Field Code
Combo Box: All/Any
Dependent DropDown
Cascading Combo Box
ComboBox Multiple Items
Lookup List Best Way
Lookup Lists 1 Table
Faster Combo Boxes
Table-based Combos
Y/N Drop Down List


Lookup List/Combo Box Yes/No Example

The Simplest of Lookup Lists - the Y/N Drop Down List

First you may say why use a Y/N field - use a check box. The answer is: don't use check boxes on forms!  They are difficult to sort by and simply clicking in or near the field will cause the value to change - often accidentally.

Use a text field in your table with a length of 1.  Put a Validation Rule such as: 'in ("Y","N")'.  Don't define a lookup in the table design (while not as important on a Y/N field, you'll see why this is discourage in discussions in our other examples).

In form design view click the icon for a Combo Box and drop it in your form.  The combo box wizard will activate.  Choose to enter your own values.  Then put a Y in the first line and a N in the second line.  In may choose a default answer in the next screen.  Finally, tell the wizard with which table field the combo box will be associated.





We have expert enterprise-level database development capabilities for cloud/web-based databases through our partnership with Jay McCormick and his team.


Find additional Combo Box examples both simple and complex in our download section:








A Blue Claw Database Design Article:

Access Form Design Help
 





Blue Claw Database Design Downloadable Tutorial:
Access Report Banding  





A Blue Claw Software Design Template:

HOA Software Template
 

Contact Information

Copyright 2000-2017 Blue Claw Database Design

Microsoft Access 2007, Access 2010, MS Access 2013