Caps on Drop-down List Items

Finding the Current Cap on List Items

If you know you need to display a large number of items in a drop-down list, you can find out whether the current cap will allow you to display that number of items. For more information and the procedure, see Viewing the Current Cap on Drop-down List Items.

Identifying When You Have Reached the Cap

Knowing whether you have reached the cap on list items is more difficult than with collections. These tips might help:

• A list has probably reached the cap if it ends arbitrarily, for example, in the middle of the alphabet in an alphabetically sorted list.
• A list has probably reached the cap if it does not contain an item that you believe it should contain.

Retrieving Additional List Items

If you have a drop-down list that does not display all the records you need to use, try these options:

• Replace the current list with a filtered list whose items match your search criteria. For more information and the procedure, see Filtering a Drop-down List.
• Right-click on the field and select Find. For more information, see Finding a Specific Value in a Drop-down List.

In most cases, you should be able to get the item you are looking for by one of these methods. Only if these methods do not return the list you need in full should you increase the cap on list items. See Changing the Cap on Drop-down Lists.