Microsoft Access - Keep An Access Form Or Report Locked In Place (Access 2002/2003)


We recently discussed how setting a form's border style to None prevents users from moving an open form. Unfortunately, this setting choice also hides the form's title bar. That means you have to implement custom ways to perform the duties normally supplied by the title bar's Close button or Control Box. Fortunately, forms in Access 2002 and later support a Moveable property that lets you both show the title bar and lock a form in place. Simply set the property to No and users can't move the form.

Go back