Trouble with controls in a form

[kruger101]

I created lots of controls on my form, and now i cannot create anymore. I do not know what the problem is... I just get an error message that says:

"MS Office Access cannot create any more controls in your form/report. If you have deleted controls from this form/report in the past, try renaming the form/report and then add more controls to it"

I tried renaming the form already. it didnt work

I tried to create a new database (i copied all the tables, queries and forms into the new database). it didnt work.


I dont know what else to do... Please help
I would dearly appreciate any help. Thank you in advance

 

[workmad3]

It sounds like you have reached the control limit for the form. VBA has an upper limit on how many controls you can create per form for some reason. I had this problem a while back, my solution was (as I was using a tab control) to move each tab into a seperate form and place them on the tab using subform controls. If you abjust the border properties of the control, you get exactly the same visual effect as if the controls are on the form, and it fixed my problem completely

 

[kruger101]

workmad3
thanks for the quick and prompt response. ill try that.