Results 1 to 8 of 8
  1. #1
    Ally1205 is offline Advanced Beginner
    Windows 7 64bit Access 2000
    Join Date
    Jul 2013
    Posts
    68

    Increasing the number of rows in combo box automatically

    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

  2. #2
    JoeM is offline VIP
    Windows XP Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    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?

  3. #3
    Ally1205 is offline Advanced Beginner
    Windows 7 64bit Access 2000
    Join Date
    Jul 2013
    Posts
    68
    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

  4. #4
    JoeM is offline VIP
    Windows XP Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    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.

  5. #5
    Ally1205 is offline Advanced Beginner
    Windows 7 64bit Access 2000
    Join Date
    Jul 2013
    Posts
    68
    Quote Originally Posted by JoeM View Post
    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
    Last edited by Ally1205; 01-17-2014 at 03:40 AM.

  6. #6
    JoeM is offline VIP
    Windows XP Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    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!

  7. #7
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,632
    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
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  8. #8
    Ally1205 is offline Advanced Beginner
    Windows 7 64bit Access 2000
    Join Date
    Jul 2013
    Posts
    68
    Joe and June,
    Thank you for this great suggestion!
    Regards,
    Ally1205

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 7
    Last Post: 10-09-2012, 02:22 PM
  2. Replies: 0
    Last Post: 02-09-2012, 05:43 PM
  3. Number of rows in a subform by combo box
    By outhwaik in forum Forms
    Replies: 11
    Last Post: 09-07-2011, 07:42 AM
  4. how to making rows look as default?
    By alex_raju in forum Access
    Replies: 1
    Last Post: 07-27-2011, 01:37 PM
  5. Stuck with combo boxes for ever !!! :(
    By Evgeny in forum Forms
    Replies: 9
    Last Post: 04-14-2010, 09:03 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums