Access because that 365 access 2021 access 2019 access 2016 access 2013 accessibility 2010 accessibility 2007 More...Less

In many database solution you have the right to store only a single value in a field. Yet in Access, friend can likewise create a field that holds multiple values (up come 100). For example, you desire to track employees working on issues. One employee deserve to own several issues, and also each problem can have actually several employee functioning on it. This sort of data framework is called a many-to-many relationship. An accessibility multivalued field is also useful when you job-related with a SharePoint perform that uses a Choice column. For a database example that uses multivalued fields, view the concern Tracking template.

You are watching: Which data type stores only one of two values

Note accessibility has other varieties of list fields: a lookup field that looks up corresponding data in a table (such as an ID ar that looks up a complete Name) and also a values list field that stores just one value with valid values characterized in a property. For much more information, see develop or delete a lookup field and Create or delete a values list field.

In this article

What is a multivalued field?

Suppose you have an concern to entrust to one of your employees, but you decide that you must assign the to more than one employee. You can develop a multivalued field that allows you select the employee from a list.


When friend click the Multi-select Combo crate arrow, check boxes show up to suggest your choices.


You can examine or uncheck items in the list and then click OK to save your choices. The selected items room stored in the multivalued field, and are be separate by commas (by default) once displayed.


The idea behind multivalued areas is to make it straightforward to those instances whereby you desire to select and also store more than one choice, without having to create a much more advanced database design. Behind the scenes, access handles this for you, automatically separating the data and bringing it earlier together again to surface the values in one field. An accessibility multivalued ar models a many-to-many relationship.

Important once you migrate an accessibility database to SQL Server, the accessibility multivalued field is convert to SQL Server as an ntext field that contains the delimited collection of values. Because SQL Server walk not assistance a multivalued data type that models a many-to-many relationship, additional design and also conversion work could be needed.

peak of page

Create a multivalued ar

Open a table in Design View.

In the very first available empty row, click in the Field Name column, and then form a field name.

Click in the Data Type pillar for that row, click the arrow and also then, in the drop-down list, pick Lookup Wizard.

Note The Lookup Wizard create three varieties of lists depending upon the selections you do in the wizard: a lookup field, a values list field, and a multivalued field.

Carefully follow these measures in the wizard:

On the an initial page, choose I will form in the worths that i want, and then click Next.

On the 2nd page, store 1 tower selected, enter several values, one in each row under the tower header, and also then click Next.

On the third page, under Do you desire to keep multiple values for this lookup?, pick the Allow lot of Values check box, and also then click Finish.

Save her changes.

peak of page

Resize a Multi-select Combo Box manage

Open the type or report in Design View or Layout View.

Click the Multi-select Combo crate control, allude to among the resize handles, and drag the leaf of the manage until it reaches the elevation or broad you want:


Access moves any adjacent controls top top the type or report bottom or to the left or right automatically.

Save her changes.

peak of page

Update the properties of a multivalued ar

When you use the Lookup wizard to create a lookup field, the Lookup ar properties are collection for you. To adjust the design of the multivalued field, collection it"s Lookup properties.

Open a table in Design View.

Click the multivalued field"s name in the Field Name column.

Under Field Properties, click the Lookup tab.

optimal of page

Delete a multivalued field

Important as soon as you delete a multivalued ar that has data, you lose that data permanently — you can not undo the deletion. For the reason, girlfriend should ago up your database prior to you delete any table fields or other database components.

Delete indigenous Datasheet view

Open the table in Datasheet View.

Locate the multivalued field, right-click the header heat (the name), and then click Delete Field.

Click Yes to check the deletion.

Delete from architecture view

Open the table in Design View.

Click the heat selector beside the multivalued field, and then press DELETE, or right-click the row selector and also then click Delete Rows.

Click Yes to check the deletion.

top of web page

Lookup ar properties

Set this property


Display Control

Set this residential or commercial property to control what properties room displayed:

Combo Box lists all easily accessible properties.

List Box lists all obtainable properties except List Rows, List Width, and Limit to List.

Text Box screens no properties and converts the field to read-only.

Row source Type

Choose even if it is to fill the lookup ar with values from an additional table or query, or from a list of values that you specify. Friend can additionally choose to to fill the list through the name of the fields in a table or query.

Row Source

Specify the table, query, or perform of worths that offers the worths for the lookup field. When the Row source Type property is collection to Table/Query or Field List, this property must be collection to a table or query surname or come a SQL statement that represents the query. When the Row resource Type residential or commercial property is set to Value List, this property have to contain a list of worths separated by semicolons.

Bound Column

Specify the tower in the row resource that supplies the value stored by the lookup field. This value can variety from 1 to the number of columns in the heat source.

The column that gives the worth to keep does not have to be the same column as the display column.

Column Count

Specify the variety of columns in the row resource that have the right to be shown in the lookup field. To choose which columns to display, you carry out a tower width in the Column Widths property.

Column Heads

Specify whether to display screen column headings.

Column Widths

Enter the obelisk width because that each column. The display screen value in a lookup field is the tower or columns that are represented in the Column Widths property as having a non-zero width.

If you don"t desire to screen a column, such as an id column, point out 0 for the width.

List Rows

Specify the variety of rows that appear when you display screen the lookup field.

List Width

Specify the width of the manage that appears when you screen the lookup field.

Limit to List

Choose even if it is you can go into a worth that isn"t in the list.

Allow lot of Values

Indicates even if it is the lookup field allows multiple values to be selected.

you cannot adjust the worth this residential or commercial property from Yes come No.

Allow value List Edits

Specify whether you can edit the item in a lookup field that is based upon a value list. When this residential property is collection to Yes and also you right-click a Lookup field that is based on a solitary column value list, girlfriend will see the Edit list Items food selection option. If the lookup ar has more than one column, this residential or commercial property is ignored.

List Items edit Form

Name one existing kind to usage to edit the perform items in a lookup field that is based upon a table or query.

See more: How Do You Round 328 Rounded To The Nearest Hundred ? Nearesthundredth

Show just Row resource Values

Show only values that enhance the current row source when Allow Multiples Values is collection to Yes.