Auto resize/fit to screen

[Developerme]

There must be some type of 'code' to enter to have forms auto resize and fit
screen in Access 2007. I've set to 'Yes' but nothing happens. What are the
steps to get the form(s) to auto resize/fit to screen?

 

[Arvin Meyer [MVP]]

There must be some type of 'code' to enter to have forms auto resize and
fit
screen in Access 2007. I've set to 'Yes' but nothing happens. What are the
steps to get the form(s) to auto resize/fit to screen?

I believe ShrinkerStretcher from Peter's Software does this:

http://www.peterssoftware.com/ss.htm

 

[Developerme]

Yes, I've demo'd that and it is really not that good. But, I was referring to
the property sheet in Access2007 that allows Autofit and Autoresize. I
changed settings to 'yes' but it doesn't do anything

 

[Arvin Meyer [MVP]]

Auto fit fits the text to the control in datasheet view. Auto resize (I
think) does the same for a form. Neither resizes to screen resolutions.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[SteveM]

I've no experience with A2K7 yet but could you add the code:
'DoCmd.Maximize' in the OnOpen event procedure?

You may want to use 'DoCmd.Restore' in the OnClose event to return sizing to
normal.

Steve

 

[Developerme]

So fit to screen only works for datasheet view and Auto resize for form view,
but only to fit the form within its own window. Not to fill up the parent
window apparently (I've tried multiple combinations and none of them worked).
So, I'll stick with DocMaximize which does work. Thanks.