How many combo boxes can be on a form in ms access 2013?

cssc1
cssc1 used Ask the Experts™
on
Since I can't get my 7th combo box to work on a for with 6 combo boxes, does ms access have a limit on the number of combo boxes on a form?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Pawan KumarDatabase Expert
Awarded 2016
Top Expert 2016
Commented:
There is no limit as far as i know.
Distinguished Expert 2017
Commented:
There is a limit but it's pretty high.  Something around 800.  Have you compacted recently?  If you add a new control by dragging it from the ribbon, what name does Access assign.  That will give you a clue how many controls have ever been on this form.  If the number is in the hundreds, you might want to rebuild the form from scratch.  Start with a blank form, copy and paste all the controls.  Then copy and paste all the code.
Jim Dettman (EE MVE)President / Owner
Most Valuable Expert 2017
Most Valuable Expert 2012
Commented:
Actually the limit for form controls is even higher; 1080 on the last version I checked.    It has slowly crept up over each version.   Specs state though that the number of controls on a form is limited to 754.

 However there is a catch there; it's given as 754 over the life time of the form.   If you add, delete, and then add a lot of controls on a form, you might hit the limit.  Once you hit that your stuck, and your left doing what Pat suggested (actually there is another way to reset it, but it's somewhat complicated).

 But in addition to that, I think you would find that a form with a lot of combo's to be very un-responsive if they were based on large record sets.   Usually if you have a form with many combo's, listbox's, or subforms, you don't populate the record sets until the first visit of the control.    This avoids a large startup delay, and optimizes performance in that if you don't visit a control, there's no performance hit.

 With all that said though, if you outlined what it is your doing in a bit more detail, that would be helpful.   You don't really say what the problem is.   Is it simply adding the control to the design surface?   or is it that the combo's are cascading and you can't link them together?  etc.

Jim.
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

John TsioumprisSoftware & Systems Engineer
Commented:
Probably you missed something that's why you are getting the 7th combobox to work....personally i feel so many comboboxes are way too many...i reckon 4 is the normal amount....maybe you need to redesign your concept....
Distinguished Expert 2017
Commented:
There isn't a "normal" limit to combos on a form except for the hard limit of controls.  It depends on your application.  Search combos tend to have high row counts but the more typical choose an option type usually have very short lists.  Combos are however a "heavy" control and so the more you have the slower the form will be.  I just found one form that has 25.  It also has a dozen tabs with subforms..

7 combos is no where near too many but you have told us what "can't get my 7th combo box to work " means.
John TsioumprisSoftware & Systems Engineer
Commented:
I meant 7 cascading combos...as many...in the area of a form you can have as many as you like...
Distinguished Expert 2017
Commented:
Cascading combos are no different from other combos.  They only "cascade" because each combo controls the selection criteria for the next one in line.  I've never actually used more than 3 but I recently was helping a member and he was using the technique to filter a form and he had 8 of them.

Author

Commented:
Thanks everyone!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial