Drop Down box and blanks

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

Guest

I have a drop down that is built from a table but the table has blank rows in
the column I am using. is there a way I can omit the blank rows when build
the drop down on the form? I have run out of ideas that I have tried.
 
Les

If your "drop-down" (combo) box is based on a query for a row source
(recommended), you can add the criterion in your query to exclude rows with
a blank. Be aware that what looks "blank" to you could be a zero-length
string (""), or could be a Null.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top