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.
![19 List Box 19 List Box](https://www.free-online-training-courses.com/wp-content/uploads/media/19-List-Box.png)
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.