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.

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.

Editor's Picks

Free Newsletters, In your Inbox