White space in Combo Boxes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
Great. Thanks Allen

Allen Browne said:
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.
Click to expand...
 
Back
Top