Data Validation "List" - Setting length of list shown

[Dave]

I am using a data validation that covers 26 rows of a list. When you click
the cell with the drop down, only 8 items of the 26 show. You have to use
the scroll bar on the right side of the drop down to see the remaining items.

Is there a way to set the DV/drop down to show all 26 items when you click
the arrow?

I appreciate any help.

Thanks
Dave

 

[Dave Peterson]

Not using data|validation.

I am using a data validation that covers 26 rows of a list. When you click
the cell with the drop down, only 8 items of the 26 show. You have to use
the scroll bar on the right side of the drop down to see the remaining items.

Is there a way to set the DV/drop down to show all 26 items when you click
the arrow?

I appreciate any help.

Thanks
Dave

 

[T. Valko]

You can use a combo box from either the Forms toolbar or the Control toolbox
and set the number of items displayed.

 

[Dave]

Thanks.

Not using data|validation.