Increasing the number of rows in combo box automatically

[Ally1205]

I want to increase the number of rows in a combo box. In the RowSource property, I have specified a number of phrases that show in the dropdown list. Howvwer, I would like other phrases that I enter into that foeld to be added to the dropdown list automatically. Is this doable?

Is there an auto-complete property that can be applied to a combo box, to ensure that each instance of an inputted phrase is spelled correctly?



Many thanks,

Ally1205

[JoeM]

I tried changing mine to 35 rows, and it works fine for me.

A few things to check:
- Is there enough room in your Form for that kind of height?
- Do you have more than 35 options in your Combo Box record source?

[Ally1205]

I think that's why it was stuck on 16 rows because I had 16 phrases specified in the RowSource property). I would like other phrases that I enter into that field via that combo box to be added to the combo box's dropdown list automatically. Is this easily doable?

Also, is there an auto-complete property that can be applied to a combo box, to ensure that each instance of an inputted phrase is spelled correctly?

Many thanks,

Ally1205

[JoeM]

It automatically has a "AutoComplete" functionality, where if you begin typing in a value, it autocompletes.
There is also a "Limit to List" property you can use to limit it to just the options listed.

Usually, the point of using a Combo Box is to limit the users to a specified list of options. So why would you want to give them the ability to enter in different options than those listed?
Typically, in the databases I use, if they want/need to specifically enter a new code, I have a separate Form for that. This helps ensure no accidental entries (or typos) get added.

[Ally1205]

It automatically has a "AutoComplete" functionality, where if you begin typing in a value, it autocompletes.
There is also a "Limit to List" property you can use to limit it to just the options listed.

Usually, the point of using a Combo Box is to limit the users to a specified list of options. So why would you want to give them the ability to enter in different options than those listed?
Typically, in the databases I use, if they want/need to specifically enter a new code, I have a separate Form for that. This helps ensure no accidental entries (or typos) get added.

Hi Joe,
It is because there are a limited number of permissible phrases that can be entered (they are districts within a county). I think I have them all listed in my RowSource property, but occasionally, I enter a new address that includes some little-known district that haven't come across before. It's not a big problem to add that district to the combo box's RowSorce list, so I guess that's probably the solution.

As for the auto-complete feature, yes, I now see that it does do that by default. Apologies for the oversight.

Many thanks for your help.

Ally1205

[JoeM]

I see what you are doing now.

Here is a better idea. Don't list them in the Rowsource property of the ComboBox. Use a table to store them all in, and then use the Table as the Source of your ComboBox.
It makes maintaining the list much easier!

[June7]

Yes, a table as RowSource allows versatility for adding items. Use combobox NotInList event to manage adding new items to a source table 'on-the-fly'.
http://support.microsoft.com/kb/197526
http://www.fontstuff.com/access/acctut20.htm
http://www.blueclaw-db.com/access_no...ed_example.htm

[Ally1205]

Joe and June,
Thank you for this great suggestion!
Regards,
Ally1205