Resize window ...

N

NP

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

Many thanks,

NP.
 
N

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.
 
D

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.
 
A

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
 
B

Bruce

Are you trying to resize the form for different screen
resolutions, or are you just trying to make the form a
specific size when it opens. If the latter, see MoveSize
in Help, or in newsgroup postings. I just use trial and
error for the MoveSize numbers, but if I used it more
often it would probably be worth the effort to determine
the exact numbers by more precise means.
The ADH code that is available online does a pretty good
job of working around a problem that Microsoft ignored.
If you use that code, you need to design your forms at the
largest screen resolution that will be used (e.g. design
at 800x600 when your operating environment has both
800x600 and 1024x768). Somebody tried to tell me in a
newsgroup posting that there should be a standard
operating environment for Access projects, but such an
assumption overlooks that not all machines in a typical
workplace environment are of the same approximate type and
configuration, and also ignores that some users have
vision difficulties necessitating a larger screen display.
I have not tried the software from PetersSoftware because
from what I can tell it replaces DoCmd.OpenForm, and in my
case I am opening my main form as the startup form, and
therefore not using OpenForm. I have read good things
about it, though.
 
N

NP

Yes I am trying just to make the form a specific size when it opens. Thaks
for that... I will have a look round and see what I can find.

Also many thanks to the other posters to this subject for their info. It may
come in handy later on.

NP.
 
Top