White space in Combo Boxes

[pompeyjim]

I have several combo boxes which hold data from 1 table. Some fields in the
table are empty but they show up in the combo boxes as blank rows. Is there
any way of stopping this from happening. I’m sure I’ve read somewhere that it
is possible. I’ve looked through all my books and I can’t find it.

 

[Allen Browne]

If you want to exclude the rows from the source of the combo where the field
is blank, create a query, and use criteria of:
Is Not Null

Then set the combo's RowSource property to the name of this query.

 

[pompeyjim]

Great. Thanks Allen

If you want to exclude the rows from the source of the combo where the field
is blank, create a query, and use criteria of:
Is Not Null

Then set the combo's RowSource property to the name of this query.