Form size

[Guest]

I want to have all the forms to open in specific sizes and do not want users
to change the size of the form. How can I do this?

 

[Chriske911]

I want to have all the forms to open in specific sizes and do not want users

to change the size of the form. How can I do this?

by setting the size in design view
and the border to dialog or thin
disable the minimize and maximize button
set a docmd.restore on the open form event

grtz

 

[Larry Linson]

I want to have all the forms to open in specific sizes and do not want
users
to change the size of the form. How can I do this?

You got an answer, but I caution that is not the "Windows Way" -- which is
that the user's desktop belongs to the user and, therefore, the user should
have control over it. Unless there is truly _compelling_ need to control the
size of the forms, I'd suggest you let the users do what they want with
them. Otherwise, if you end up with some dissatisfied and angry users, don't
say no one warned you beforehand.

Larry Linson
Microsoft Access MVP

 

[Guest]

How do I disable the minimize/ maximize button?
Thank you,

 

[Roger Carlson]

In the Form Properties, set the Control Box property to No.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Guest]

Mr. Carlson,
I'm so glad that you responded!
Thank you for the tip.

I have been working on a database and modified the "Ad-Hoc Report.mdb" from
KayKomuro's Library (which was linked to your library). I don't know if
you're familiar with that, but I haven't yet received a reponse from Ms.
Komuro, so I hope that perhaps you can help. The Form from the "Ad-Hoc" opens
up maximized. I want it to open up minimized for my users. How do I do that?

The "Ad-Hoc" reports based on specified criteria. It is just what I was
looking for...except for an inablility to save unique reports.
I preview and then save any report (using the right click mouse command).
Then I clear the form, and requery to create a different report, and save
it. When I open the first report, it shows data from the second. (all reports
created show data from the most previously saved report!)

I would appriciate any recommendations on these two topics, and I truly
appriciate your time and talent (it keeps beginners like me from pulling out
all of our pretty hair!)
Thanks,