Access 2003 makes it easy to add a value list to your combo
box controls. Instead of working with the property box, the Combo Box wizard
guides you in setting up the control in a few steps. For example, suppose for
the Marital Status field in your employee database, you want to limit the
options to: Married, Never Married, Divorced, or Widowed. To create a combo box
to do this, follow these steps:

  1. Open
    the Employee Data form in design mode.
  2. Click
    the Combo box tool on the toolbox and drag it to insert the control on the
  3. In the
    Combo Control Wizard window, select I Will Type In The Values, then click Next.
  4. Enter
    Married, then click Tab.
  5. Enter
    Never Married, then click Tab.
  6. Enter
    Divorced, then click Tab.
  7. Enter
    Widowed, then click Tab.
  8. Click Next and then click Store Value In and select the
    Marital Status field in the drop-down box.
  9. Enter
    Marital Status, then click Finish.

Miss a tip?

Check out the Microsoft Access archive, and catch up on our most recent Access tips.

Help users increase productivity by automatically signing up for TechRepublic’s free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.