If you want to display the current data from a record source, click I want the list box/combo box to look up the values in a table or query. When the wizard asks how you want to get the values for the control, do one of the following: On the form, click where you want to place the list box or combo box.ĭepending on your choice, the List Box Wizard or the Combo Box Wizard starts. On the Design tab, in the Controls group, ensure that Use Control Wizards is selected.Ĭlick either the List Box tool or the Combo Box tool. On the Data tab of the property sheet, the Record Source property box displays the table or query that the form is bound to. To determine if the form is bound to a table or query, press F4 to display the property sheet. Some of the steps will not apply if the form is unbound. Note: This procedure assumes that the form is bound to a table or query. Right-click the form in the Navigation Pane, and then click Design View. Top of Page Create a list box or a combo box by using a wizard This makes it possible to create the relationships that are needed to link the data in the list box or combo box to the data on the form. To create a bound list box or combo box that looks up values in a table or query, make sure the form is based on a record source that includes a foreign key field or Lookup field. These controls can look up values in a fixed list that you type yourself, or they can look up values in a table or query. List boxes and combo boxes can be bound or unbound controls. Click the arrow to display the drop-down list.Ģ. In this way, the combo box control combines the features of a text box and a list box.ġ. A combo box also gives you the ability to enter a value that is not in the list. The user is limited to the choices given in the list box it is not possible to type a value into a list box.Ĭombo box The combo box control provides a more compact way to present a list of choices the list is hidden until you click the drop-down arrow. If the list has more rows than can be displayed in the control, Access displays a scroll bar in the control. The rows can have one or more columns, which can appear with or without headings.
The list box contains rows of data, and is usually sized so that several rows are visible at all times. List box The list box control displays a list of values or choices.
Learn about the types of list box controlsĬreate a list box or a combo box by using a wizardĬreate a list box or a combo box by adding a Lookup field to a formĬreate a list box or a combo box without using a wizardĪccess provides two list controls for forms - the list box and the combo box.
#Microsoft access on mac zoom box how to#
Read on to learn about the list controls available for Access forms, and how to create and customize them. A list control can connect to existing data, or it can display fixed values that you enter when you create the control. A list of choices also helps ensure that the value entered in a field is appropriate. When entering data on forms in Access desktop databases, it can be quicker and easier to select a value from a list than to remember a value to type. Access for Microsoft 365 Access 2021 Access 2019 Access 2016 Access 2013 Access 2010 Access 2007 More.