Resize main form and subform?

  • Thread starter Thread starter Kiers
  • Start date Start date
K

Kiers

Hi All,

i have form with a subform (datasheet view) with the 'border' property
of the main form set to 'sizeable', is it possible for the subform to
automatically resize in line with the main form? Currently the subform
size remains fixed, which distorts the whole form. the reason being, i
want my users to be have the flexibility of setting some form sizes to
meet their own requirements.

Any assistence will be appreciated.

(Access 2007)

Rgds

Kiers
 
Kiers said:
Hi All,

i have form with a subform (datasheet view) with the 'border' property
of the main form set to 'sizeable', is it possible for the subform to
automatically resize in line with the main form? Currently the subform
size remains fixed, which distorts the whole form. the reason being, i
want my users to be have the flexibility of setting some form sizes to
meet their own requirements.

Any assistence will be appreciated.

(Access 2007)
Click to expand...


Yes, you can use the Resize event of the main form adjust the height and
width of the subform based on the current InsideHeight and InsideWidth of
the main form. For example:

Private Sub Form_Resize()

Me.sfMySubform.Height = Me.InsideHeight - 100
Me.sfMySubform.Width = Me.InsideWidth - 200

End Sub

Note that I've only actually done this to adjust the height of a continuous
subform. Tweaking the width may possibly involve some additional
adjustments; I can't really say.
 
Yes you can do this by selecting the sub-form and changing the Horizontal and
vertical Anchor Properties to "Both"
 
Yes, you can use the Resize event of the main form adjust the height and
width of the subform based on the current InsideHeight and InsideWidth of
the main form.  For example:

    Private Sub Form_Resize()

        Me.sfMySubform.Height = Me.InsideHeight - 100
        Me.sfMySubform.Width  = Me.InsideWidth - 200

    End Sub

Note that I've only actually done this to adjust the height of a continuous
subform.  Tweaking the width may possibly involve some additional
adjustments;  I can't really say.
Click to expand...

Hi Dirk,

thanks for your time.

Height adjustment works fine. Now encouraged to sort out the width and
also move 'buttons' (that are on the main form) as the form resizes.

Rgds

Kiers
 
Kiers said:
Height adjustment works fine. Now encouraged to sort out the width and
also move 'buttons' (that are on the main form) as the form resizes.
Click to expand...

Very good. Good luck with it!
 
FrozenJackal said:
Yes you can do this by selecting the sub-form and changing the Horizontal
and
vertical Anchor Properties to "Both"
Click to expand...


Neat! That's a new feature of Access 2007 that I wasn't aware of. If I
were Kiers, I'd give that a try in place of the code approach I suggested.
 
Neat!  That's a new feature of Access 2007 that I wasn't aware of.  If I
were Kiers, I'd give that a try in place of the code approach I suggested..
Click to expand...

Hi Again,

thanks for the responses. I got the subform to work. but not quite yet
for the controls. I think this is to do with the construction of the
form;

The main form has 4 pages, each page has its own subform. The controls
move as expected when the form size is increased, but they do not move
when the form size is decreased (horizontally). The controls
horizontal anchor is set to 'left' and vertical is set to 'bottom'.

Any suggestions would be appreciated.

Rgds

Kiers
 
Back
Top