Subform resizing BUG?

[iordanis]

Hi!
1) I use some tab pages to organize my master/detail data, so i have a subform in each one.
2) The whole tab control uses Both in Horizontal and Vertical anchoring, so it uses the whole form's size.
3) Sometimes, depending on my data, I need to resize the subforms in a tab page.

But, when i decrease the current subform's height using VBA, it doesn't decrease its as displayed in Form View, but as it was set in DESIGN TIME (!). So, in a fairly large form where all controls cover enough space, if I decrease the subform's height, it could go negative, although its displayed size is still enough.

Use the attached file, resize the form enough and then use the [- Child1 height] button multiple times (hold Enter), to reproduce the problem.

IS THIS STUPID BEHAVIOR A BUG?
(I use Access 2013. I don't know if the same problem still exists in newer versions)



TIA.

[June7]

Why do this? This is why forms have scroll bars.
With + sizing subform container grows until it covers buttons and continuing expands the tab control.
Then - sizing until form almost disappears and triggers error.
Tested with Access 2010.
I will have to try on other PC with 2021.

[iordanis]

Isn't Access' behavior strange?

The reason I organize controls this way, is that I want everything to be on-sight when the user displays a tabpage, rather than scrolling up/down like in a webpage.

[June7]

Why would you consider Access's behavior strange?

Not understanding what you mean by "everything to be on-sight". What is "everything" - all records?

Maybe providing db with actual implementation of this method could clarify.

[iordanis]

I mean, all fields of a detail record.

Strange it is, because using Horiz/Vert anchoring, the actual height/width of a control changes. If I then choose to increase/decrease it by code, shouldn't it use the displayed height/width and not the one in design time?

[June7]

Okay, now I see the issue. I had used + Size before - Size.

I really think "it is what it is" and beyond my interest to pursue any further.

Good luck.

[jojowhite]

that is not a BUG.
if you resize it using VBA, resize the rest using VBA.