Prevent users from resizing Access report windows

by Mary Ann Richardson | May 23, 2006 7:00:00 AM

Tags: Construction, Microsoft Office, Databases, Mary Ann Richardson, Microsoft Access, Border Style property, Border Style, window, Microsoft Office Suite Access Tips Newsletter

Takeaway: Working with Access pop-up windows, dialog boxes, or forms that absolutely, positively must not be resized? Mary Ann Richardson explains how to use the Border Style property in Access 2002 and 2003 to lock your windows into a desired size.

Does your application include a pop-up report or form window that you do not want users to resize? With the Border Style property introduced in Access 2002, you now have a way to prevent users from moving or resizing a pop-up window.

For example, if you want to prevent users from changing the size of a pop-up report, follow these steps:

1. Open the report in Design view and double-click the Report Selector button.
2. Click the Pop Up property in the Other tab and select Yes from the drop-down menu.
3. Click the Border Style property from the Format tab and select Thin from the drop-down menu.

(If the pop-up is a dialog box, select Dialog instead of Thin in order to prevent users from minimizing or maximizing the window; users will only have the Close button available to them.)

If you prefer, you can omit the window border altogether by selecting None for the Border Style property.

Miss a tip?

Check out the Microsoft Access archive, and catch up on our most recent Access tips.

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.