To display a multivalued field in expanded form so that each value is displayed on a separate row in a query,set the ____ property for the field.
A)Lookup
B)Value
C)Row Source
D)Validation Rule

Question

Quizplus · Accepted Answer

The Value property is used to set the value or values displayed in a field. By selecting the multivalue option in the property sheet, Access will automatically display each value on a separate row when the field is included in a query. The Lookup property is used to display a list of values for the user to choose from but will not expand multiple values into separate rows. The Row Source property is used to specify the list of values for a lookup field, but it does not control how the values are displayed in a query. The Validation Rule property is used to set rules for data entry and does not affect how a multivalued field is displayed in a query.

To Display a Multivalued Field in Expanded Form So That