Solved: Hide blank values in a drop downbox?

[lienlee]

I have a drop down box and its using an index to grab what values are to be in the box. However. Some of of the index(a column) has blank values. and i dont want them to appear in my dropdownbox. Is there a way to do this without coding.

[Imdabaum]

Open the design view and go to the properties of the dropdownbox. Open the Row Source builder in the Data tab. Click the ... button and add Is Not Null to the fields that show up blank in the drop down selection.