You can use a combo box from the Forms toolbar. You can specify how many
items are displayed. A combo box is similar to a data validation drop down
list but there are some significant differences. A combo box drop arrow is
always visible unlike the dv list. Also, if you use the selected value in
other calculations, a combo box needs a linked cell and this linked cell
returns the NUMBER of the item that was selected.

Biff

"jenn" wrote in message
...
my validations list shows the first 6 items and I have to scroll for the
rest. Anyway to show more items with the initial click?