Removing Blanks From a Dropdown or Listbox

To remove blanks from a dropdown or listbox, use a View that filters out the blank entries instead of using a table as your lookup. Refer to instructions to filter the table by using a View mentioned in this article View to filter a Table. Use Comparison type “Is Not Blank” for the field that has the blanks.