G
Guest
Hi, I have a basic combo box that displays a list from a Table field.
Sometimes the record in that particular field is blank or (null)
This shows as a space in the combo box drop down list also.
Is there a way to tell the combo box to list only records with values?
So there are not spaces in the drop down list.
I'm also using a query in this combo box for ascending from A to Z.
This puts all the blank (null values) at the top of the drop down list, but
doesn't remove them.
Is there a filter, function, expression, or procedure to fix this?
I'm brand new to Access, but have some elementary knowledge of VB.
Thank you for your time, Amy.
Sometimes the record in that particular field is blank or (null)
This shows as a space in the combo box drop down list also.
Is there a way to tell the combo box to list only records with values?
So there are not spaces in the drop down list.
I'm also using a query in this combo box for ascending from A to Z.
This puts all the blank (null values) at the top of the drop down list, but
doesn't remove them.
Is there a filter, function, expression, or procedure to fix this?
I'm brand new to Access, but have some elementary knowledge of VB.
Thank you for your time, Amy.