Gaps in Drop down list....?

[bluenose76]

I have a form that displays the results of a query.

the displayed results are controlled by a Combobox and this all works fine, however when i select the drop down list, there are gaps between the data that is displayed?

I realise that this is more than likely due to the fact that there is not an entry in this colums for every record in my table, However is there a way that I can force the combobox / drop down list to list them without spaces?

 

[boblarson]

Use a query for the rowsource in the combo box and use Grouping

to group so you only have one of each item, if there are multiples showing up, and put IS NOT NULL in the criteria of the rowsource query for the column where your blanks are so no nulls will show up.

 

[ajetrumpet]

Iwhen i select the drop down list, there are gaps between the data that is displayed?

GAPS horizontally, or vertically??

However is there a way that I can force the combobox / drop down list to list them without spaces?

If vertically, there is only 1 possibility...

Exclude the records that contain the NULL field values that are showing up in the Rowsource

WHERE [field] Is Not Null

 

[bluenose76]

Bob,

That worked a treat and it seems to be working fine now.

Thank you.