Table - Creating a combo box

In many cases, it's quicker and easier to select a value from a list than to remember a value to type.  In a combo box, you can type a value or click the arrow to select an item in the list that drops down.  It is much easier to click on a down arrrow, and select a word than having to type it in. 

A combo box is a control in a table or a form that is like a list box and a text box combined.  Combo boxes can be used with all data types except Memo and OLE objects.

To create a combo box in a table

Select the required field where you wish to add a quick list of values or words; in the example, it is the Title field name.

Click the Lookup tab in the field properties pane.   In the Display Control field an arrow appears.  Click the arrow and then select Combo Box.

In the Row Source Type field click Value List.  

In the Row Source box add the values or words required.   Try to list them in a suitable or alphabetical order.  Note the punctuation marks between the values. 

To add the values or words you could also right-click on the Row Source field.  Select Zoom. 

Add the values or words required.  Click OK.

The required values or words are added quickly to a table. 

If you wish to limit the values or words to the given list, select Limit To List.

This work may be freely copied for non-commercial use only. Copyright © Pam Miller