White space in combo boxes

  • Thread starter Thread starter jimblob21
  • Start date Start date
J

jimblob21

I have a subform with several combo boxes on it which hold data from
table. Some fields in the table are empty but they show up in th
combo boxes as blank rows. Is there any way of stopping this fro
happening. I’m sure I’ve read somewhere that it is possible but I’v
looked through all my books and I can’t find it
 
Build a query to pull from the table and set criteria for the blank field to
NOT NULL.

Use the query as source instead of the table.
 
You must log in or register to reply here.

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

Blank combo or list box 1
Showing combo box box that's not an option in its drop-down list 5
Access Control on subform / combo box requesting parameter 0
Unbound combo box 6
Blank combo box 4
White space 5
combo box in subform? 4
Autopopulate text box based on an unbound combo box 4

Back
Top