ComboBox Drop Down

[davies107]

Hello everyone,

I am having a problem how to solve my combo box drop down. I wanted it to have no spaces or no extra rows below the last record whenever the combobox is clicked and scrolled down.

BTW, I attached a picture.

Thanks

 

[RuralGuy]

The "ListRows" property controls how many rows are displayed when it drops down.

 

[davies107]

it has 16 and i changed it to 5 but still a lot of spaces below the record.

number of rows in the entire table is 4,000+

 

[RuralGuy]

What version of Access are you using?

 

[davies107]

Access 2010

 

[RuralGuy]

Hmm...I looked at one of my ComboBoxes and ListRows is set to 16 but there is only 1 record in the RowSource and that is all that displays with *no* extra space below. I'm not sure what is happening on your form.

 

[joemach]

Hello everyone,

I am having a problem how to solve my combo box drop down. I wanted it to have no spaces or no extra rows below the last record whenever the combobox is clicked and scrolled down.

BTW, I attached a picture.

Thanks

Put "Not Is Null" in the Criteria row for the field in the query. Without the quotes.

Let us know how that goes.

 

[davies107]

Put "Not Is Null" in the Criteria row for the field in the query. Without the quotes.

Let us know how that goes.

i tried to several comboboxes in my DBS but nothing happens.