MoveSize limited to screen height?

[Mark B]

Hi

I want to resize a form so that before it prints, it fills up a portrait US
Letter page.

I am trying to use Docmd.MoveSize to make it quite high, though the action
will only stretch the window to the limit of the Access window. That would
be OK if the users were at 1600x1200 resolution, but it's not OK if the are
at 1024x800.

Any suggestions?

Thanks
Mark

[Marc]

"Mark B" <remove_from _h*********************@ihug.co.nz> wrote in message news:<bj**********@lust.ihug.co.nz>...

Hi

I want to resize a form so that before it prints, it fills up a portrait US
Letter page.

I am trying to use Docmd.MoveSize to make it quite high, though the action
will only stretch the window to the limit of the Access window. That would
be OK if the users were at 1600x1200 resolution, but it's not OK if the are
at 1024x800.

Any suggestions?

Thanks
Mark

Mark,

Just stretch the form in design view to the desired size.
You also can do it dynamically by VBA through Me.InsideHeight = <twips?
When your display is smaller, just sliders will appear.

Marc