Max number of controls on form message
- Thread starter skelley
- Start date
Can you put subforms on your tabs and then put the controls for each tab on that subform?
[It is actually done the other way...you would make the form (subform) first, then add a subform control to your tab (and set the control source to your new form) in place of all of the controls]. This should bring down the number of controls on the main form. You can then link the subform control to the main form in order to show the correct records in your subform.
Hint: Copy/ Cut / Paste works really well for moving controls from one form to another without having to reset all of the properties! But, if you have any code behind any of the controls, you may have to copy that separately. The code will still remain in the form module until you manually remove it ( it doesn't get removed just because you deleted the control)
[It is actually done the other way...you would make the form (subform) first, then add a subform control to your tab (and set the control source to your new form) in place of all of the controls]. This should bring down the number of controls on the main form. You can then link the subform control to the main form in order to show the correct records in your subform.
Hint: Copy/ Cut / Paste works really well for moving controls from one form to another without having to reset all of the properties! But, if you have any code behind any of the controls, you may have to copy that separately. The code will still remain in the form module until you manually remove it ( it doesn't get removed just because you deleted the control)
R. Hicks
AWF VIP
- Local time
- Today, 14:26
- Joined
- Dec 23, 1999
- Messages
- 618
How many are on the form? The limit is 255, that's a lot of controls. If you don't have that many, compact the database and you will not receive the message. Access keeps count of the controls as you place them on the form. But if you delete some (or one), the count is not decreased until you compact the db.
HTH
RDH
HTH
RDH
