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

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?
cssc1Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Pawan KumarDatabase ExpertCommented:
There is no limit as far as i know.
0
PatHartmanCommented:
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.
1
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
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.
0
Determine the Perfect Price for Your IT Services

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

John TsioumprisSoftware & Systems EngineerCommented:
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....
0
PatHartmanCommented:
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.
0
John TsioumprisSoftware & Systems EngineerCommented:
I meant 7 cascading combos...as many...in the area of a form you can have as many as you like...
0
PatHartmanCommented:
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.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
cssc1Author Commented:
Thanks everyone!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.