How to remove blanks from a dropdown or listbox?

 

Question:

How to prevent blank entries or lines from displaying in a dropdown form element?

 

Answer:

Rather than using a table as your lookup, use a View that filters out the blank entries.

See how to create a view to filter records here. Use Comparison type "Is Not Blank" for the field that has the blanks.