Good morning, I have a mask with 2 continuous subforms inside that report data from a query. Each in each record of the main form can contain one, two or more rows. I would like the height of each subform to be proportional to the number of rows (if the subform A has a record of a height, if the subform B has 3 records it will have a greater height).I tried to insert on the Current event of the main form the code indicated here on this forum (sorry I'm not going to put the link):
me.subformname.height = me.subformname.form.section (0) .height * (me.subformname.form.count + 1)
indicating only one of the two subforms to try, but unfortunately the height of the subform is increased a lot. Not being an expert on vba I wonder if this may depend on the fact that on Current of the mask I already have another code, to which I added this below. Thank you
me.subformname.height = me.subformname.form.section (0) .height * (me.subformname.form.count + 1)
indicating only one of the two subforms to try, but unfortunately the height of the subform is increased a lot. Not being an expert on vba I wonder if this may depend on the fact that on Current of the mask I already have another code, to which I added this below. Thank you