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

True/False Combo Box
Access Combo Box


Updated On 7/19/2017 6:45:01 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
Dynamic List Box


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.



Our Access Programmers work with clients all over the world through the Internet. See why we are the: the best Access programming company.

We also have 100's of programming examples from simple to complex. You can jump to our Access tutorials here.


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








A Blue Claw Database Design Article:

How To Create Faster Access Databases
 





Blue Claw Database Design Downloadable Tutorial:
How To Perform Inventory Calculations (Multi-User)  





A Blue Claw Software Design Template:

Barcode-Device Inventory Database
 

Contact Information

Copyright 2000-2017 Blue Claw Database Design