title: Controlling size of forms
body: <p>So I have an Access application, and I'd like some forms to be maximised when they are opened, and others to be medium-sized when they are opened.  However, if I try something like this:</p>
  
  <pre><code>Private Sub Form_Activate()
    DoCmd.Maximize
  End Sub
  </code></pre>
  
  <p>or</p>
  
  <pre><code>Private Sub Form_Activate()
    DoCmd.Restore
  End Sub
  </code></pre>
  
  <p>it has the effect of maximizing or restoring every open window, which isn't what I'm looking for.</p>
  
  <p>Is there any way around this?</p>
  
  <p>I'm using Access 2003.</p>