Freeze the MS Access window size

[Lauren Quantrell]

Is there a way in code to freeze the size of the MS Access window or to
prevent it from being sized?
Thanks.
lq

[Ed Robichaud]

There are third-party tools to d
"Lauren Quantrell" <la*************@hotmail.com> wrote in message
news:11*********************@g49g2000cwa.googlegro ups.com...

Is there a way in code to freeze the size of the MS Access window or to
prevent it from being sized?
Thanks.
lq

[Ed Robichaud]

There are third-party tools to dynamically re-size froms, but they can be
used in reverse to "lock" a size. However, you can simply set your forms'
Border Size property to "Dialog" ; this will prevent resizing from the
original design. Also consider the control buttons to Min/Max/Restore
window size, the AutoCenter and AutoResize form properties, and whether you
need Pop-up andor Modal properties.

You ask about the Access window, so not really sure what you're try to
accomplish. Most Access applications are a series of forms/menus, and the
developer determines what should be visible and where.
-Ed


"Lauren Quantrell" <la*************@hotmail.com> wrote in message
news:11*********************@g49g2000cwa.googlegro ups.com...

Is there a way in code to freeze the size of the MS Access window or to
prevent it from being sized?
Thanks.
lq

[Lauren Quantrell]

I am opening a dialog form (non-popup) maximized within the Access
application. I don't want the user to be able to size the Access window.

[Larry Linson]

"Lauren Quantrell" wrote

I am opening a dialog form (non-popup)
maximized within the Access application.
I don't want the user to be able to size
the Access window.

That is not really user-friendly -- the "Windows Way" is to allow the user
to control his/her own desktop. There are occasionally, _compelling_ reasons
for not allowing that, but the reason should definitely be a _compelling_
one, not just a matter of developer preference.

Larry Linson
Microsoft Access MVP

[AP]

I know that it may not be '_user_friendly_' but if you need to do it,
one way is to make the border style thin and then on the on open event
of the form set docmd.maximize. You will probably also want to disable
the min and max buttons in the form properties as well. If you are
trying to control the sizing of the actual database window (shows your
table, queries and forms) I'm not sure if this is possible, but I would
suggest hiding the database window on open using the tools...startup

[Lauren Quantrell]

This is a non-popup form, maximnized within the MS Access database
window and what I want to do is prevent the user from sizing the MS
Access window hwile this form is displayed. The alternative is to make
it a popup form and hide the Access window entirely which is what I'll
do instead, unless there is a simpe code solution.

[Stephen Lebans]

There is no simple code solution. You would have to subclass the main Access
App window.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"Lauren Quantrell" <la*************@hotmail.com> wrote in message
news:11**********************@g14g2000cwa.googlegr oups.com...

This is a non-popup form, maximnized within the MS Access database
window and what I want to do is prevent the user from sizing the MS
Access window hwile this form is displayed. The alternative is to make
it a popup form and hide the Access window entirely which is what I'll
do instead, unless there is a simpe code solution.