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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Excel: How do I put a formula in a drop down list 11
Formatting combo box drop-down list 1
Label based on drop-down box selection 3
Filtered Drop Down Menu Based on Previous Drop Down Selection 1
Lookup value and control depends on lookup result 1
Adding ALL to drp down list 10
Filtered drop down list 2
Copy record in one form into a new pop-up form 0

Back
Top