Create a query.
In query design, in the Criteria row under this field, enter:
Not Null
Use this query as the RowSource of your combo.
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users -
http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"AA Arens" <ba***********@gmail.com> wrote in message
news:11*********************@i40g2000cwc.googlegro ups.com...
I have a combo-box and let the list ordered by a field-name.
How to have the empty values of this field ignored (not listed)?