Advanced Database – bound controls: list box

Create, modify, delete bound controls: list box

A list box is similar to a combo box, but you cannot enter values manually.

They are a good option if you want to tightly control which values can be entered for a certain field.

7 List Box Replace

Open the Jobs Entry form in design mode by right clicking and selecting Edit.

CTRL right click on the Car Reg No input box, select ‘Replace with’ and choose List box.

8 Properties List Box

Right click and select ‘Control’ and click the Data tab.

The Type of list contents defaults to ‘Valuelist’ for a list box.

This means we can enter the list of values manually by clicking list content and writing each value in quotation marks, pressing SHIFT + ENTER to go to the next value (as we did in an earlier lesson).