Prevent users from resizing an Access form - TechRepublic
Software
SHARE
Facebook X Pinterest WhatsApp

Prevent users from resizing an Access form

Even though users can resize Microsoft Access form windows, there may be times when you want to stop them from modifying the form. Learn how to do so in five simple steps.

Written By
maryannrichardson
maryannrichardson
Jun 21, 2005
We may earn from vendors via affiliate links or sponsorships. This might affect product placement on our site, but not the content of our reviews. See our Terms of Use for details.

By default, Microsoft Access form windows act like any other
window; users can change their size and position using the windows border
features. But if you would like to prevent users from modifying how the form
displays on the screen, follow these steps:

  1. Open
    the form in design view and press [F4].
  2. Under
    the format tab, change the value of MinMaxButtons property to None.
  3. Change
    the value of Control Box to No.
  4. Change
    the Border Style to Thin.
  5. Set
    the value of Moveable to No.

When the form is opened, the user will not be able to use
the border buttons to resize, minimize or maximize the form. With Moveable set
to No, users will not be able to click and drag the border to reposition the
window on the screen.

Help users increase productivity by automatically signing up for TechRepublic’s free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.
maryannrichardson