Solved Form layout: 2 subforms filling the form for 50% each

[Martin123]

Hi there, this is my first post! I have some experience managing an Access project (including the VBA code behind it), but it's mainly self-taught. I use the Access version from Microsoft 365.

My question: Is it possible to scale two subforms in one form equally, so that they'll each take up 50% of the screen (one on the left side, and one on the right side)? The idea is to have the parent data on the left, and when the user selects a row, the subform on the right will show the data that is part of that parent. Both subforms would be datasheet views. I know it's possible to have the two subforms, but I can't get the alignment to work. None of the anchoring options in the arrange tab seem to get to the wanted behaviour.

I also tried this using VBA, where you could set the left and width properties during the Form_Load (and later on in the Form_Resize) events. However, Form.Width is not the full width of the screen as it turns out since it repositions the widgets but not where i want them.

Private Sub Form_Load()
    With Me.leftSubform
      .Left = 0
      .Width = Form.Width / 2
    End With
    
    With Me.rightSubform
      .Left = Form.Width / 2
      .Width = Form.Width / 2
    End With
End Sub

What am I missing?

Thanks in advance

 

[arnelgp]

inspect the InsideWidth property of the form and do it in the Resize event of the form to resize your subform.

 

[Josef P.]

Tip: use layout + anchor => works without code

 

[CJ_London]

Is it possible to scale two subforms in one form equally, so that they'll each take up 50% of the screen

Just be aware that many screens are much wider than the maximum width of a form (22”) so if your form is maximised you will get an error.

 

[arnelgp]

i also use the Vertical Anchor of the two subforms.
and again i use the Main form's Resize event to resize the two subforms and re-establish the Left property of subform 2.

there are two samples 1 is pop-up and the other is not.

 

[arnelgp]

Tip: use layout + anchor => works without code

it will work when you make the main form large.
but when you drag it to make it smaller, the problem arises.

 

[Josef P.]

If you design the main form in the smallest size to be used, it will run without problems.
A size of the main form of 1x1cm probably nobody will want to use.

If it needs to be more flexible, you can always react to the resize event.
But sometimes the simple variant is enough.

 

[Martin123]

Hi guys, thanks for the quick responses! I currently fixed it using the insideWidth property as suggested by @arnelgp! This seems to work for my use case. I didn't know this property existed.

 

[arnelgp]

i forgot to upload another 2 forms that has small equal margins on each side of the subforms.
just a demo (forms, 21popUpWithMargins and 22NotpopUpWithMargins)