Resize window ...

[NP]

Looking for a way to resize a window when a form is opened. Any ideas
please?

Many thanks,

NP.

 

[Arvin Meyer]

There is some code in the Access Developer's Handbook, by Ken Getz. And you
may also be interested in Shrinker-Stretcher by Peter DeBaets:

http://www.peterssoftware.com/index.htm
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[NP]

Unfortunately I don't have a copy of the book you mentioned and was looking
for some free code if at all possible to be able to do this.

Any more ideas please?

NP.

 

[Arvin Meyer]

That code is copyrighted and can't be republished without the author's
permission. The Access Developer's Handbook is certainly well worth the
investment if you're a serious developer.

I believe Ken Getz has made some code available on his website:

http://www.developershandbook.com/Downloads/ADHResize.zip
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Douglas J. Steele]

Actually, I believe that's an MDE add-in that can be included in a project,
but it doesn't actually show the code.

 

[Arvin Meyer]

There are samples that will show him how to resize his own forms. All he
needs to do is set a reference to the MDE (it's not really an add-in, but
works like one) for the version of Access he needs, and use the same code in
his forms that is used in the sample forms. The code in the sample
applications can almost be imported directly with little if any changes.
There's also a large PDF with an explanation of how everything works.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access