Free Online Training Courses

Advanced Database – bound control properties

Apply, remove bound control properties like: limit to list, distinct values.

Limit to list and distinct values options are only available in MS Access, not Libreoffice Base.

[the_ad id=”12355″]
[the_ad id=”12356″]
19 List Box

Limit to list changes the properties of a combo box to only allow values from the list.

To do this in Base, you simply need to select the combo box, right click and select Replace with -> List Box

Then enter or link to values in the list box as shown in a previous lesson.

[the_ad id=’12397′]