subform resize???

  • Thread starter Thread starter SuzyQ
  • Start date Start date
S

SuzyQ

I want to resize the width of the subform when the form is resized. I put
the code below in my project, but it is not working. Can someone help me
resize my subform on the fly?

Private Sub Form_Resize()
Me.frmInvoiceLineItemsListSubform.Width = Me.Width - (0.25 * 1440)
End Sub
 
Hi SuzyQ,
you need to resize the subform control and probably also the subform inside
the subform control.
The easiest way I have found to get this to work, is to give the subform
control a colored border, manually change the size and switch to form view
to see what happens. The bright colored border makes it easier to see what
is happening. Once you have got it worked out, you can set up the code to
make it happen on the fly and remove the bright colored border.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia
 
Do you have a sample of code for one that you've got to work? I'll see if I
can do what you're saying, but not sure why code below isn't working.
 
Hi Suzy

Me.Width does not change as you resize a form. Use Me.InsideWidth instead.
 
that did it. thanks

Graham Mandeno said:
Hi Suzy

Me.Width does not change as you resize a form. Use Me.InsideWidth instead.

--
Good Luck :-)

Graham Mandeno [Access MVP]
Auckland, New Zealand

SuzyQ said:
I want to resize the width of the subform when the form is resized. I put
the code below in my project, but it is not working. Can someone help me
resize my subform on the fly?

Private Sub Form_Resize()
Me.frmInvoiceLineItemsListSubform.Width = Me.Width - (0.25 * 1440)
End Sub
Click to expand...
Click to expand...
 
Back
Top