<div>
Put this code into the main form's Resize event:<br />
&nbsp; &nbsp; Const LeftRightPadding = (0.125 + 0.25) * 1440<br />
&nbsp; &nbsp; Const TopBottomPadding = (0.65 + 0.375) * 1440<br />
&nbsp; &nbsp; <br />
&nbsp; &nbsp; Me.sfrmClient.Height = Me.InsideHeight - TopBottomPadding<br />
&nbsp; &nbsp; Me.sfrmClient.Width = Me.InsideWidth - LeftRightPadding<br />
<br />
You'll need to change the subform references and play with the numbers in the constants. &nbsp;The top and bottom padding are the most difficult to adjust. &nbsp;The distance from the top of the main form plus the size of the header will impact the numbers.
</div>


Put this code into the main form's Resize event:
    Const LeftRightPadding = (0.125 + 0.25) * 1440
    Const TopBottomPadding = (0.65 + 0.375) * 1440
   
    Me.sfrmClient.Height = Me.InsideHeight - TopBottomPadding
    Me.sfrmClient.Width = Me.InsideWidth - LeftRightPadding

You'll need to change the subform references and play with the numbers in the constants.  The top and bottom padding are the most difficult to adjust.  The distance from the top of the main form plus the size of the header will impact the numbers.

<div>
That did the trick. I didn't know 2010 had added Anchoring. Thanks much!<br />
<br />
(the other expert answer deserves kudos for pre-2010 versions. Thanks both)
</div>


That did the trick. I didn't know 2010 had added Anchoring. Thanks much!

(the other expert answer deserves kudos for pre-2010 versions. Thanks both)

<div>
<div class="content wysiwyg-content">
I'm looking for (hopefully simple) sample code to maximize a subform within the Detail section of a main form whenever the main form resizes.<br />
<br />
Seems it should be simple, but it's eluding me.
</div>
</div>


I'm looking for (hopefully simple) sample code to maximize a subform within the Detail section of a main form whenever the main form resizes.

Seems it should be simple, but it's eluding me.

MS Access 2010 - Maximize subform on Main form resize

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.