title: How can I dynamically set all the Application Forms Caption property
body: <p>I have one Access application which accesses 3 environments (DEV; TEST; PROD).  An environment variable is set upon login to programmatically connect to the correct database.</p>
  
  <p>We would like the user to see which environment they are connected to in each form they use.  One thought is to set the color of the title bar, but that impacts all windows.</p>
  
  <p>I have been attempting to put the environment in the form caption dynamically by using the environment variable.</p>
  
  <p>Setting an Event Procedure in the Form Properties such as On Current or On Open such as:</p>
  
  <p>Me.Caption = Me.Caption &amp; "  :  " &amp; Me!txtEnvName.Value</p>
  
  <p>.... in a dynamic process upon signin to the application is what I would like to do.</p>
  
  <p>Manually changing all the forms in the application is not a desired option.</p>
  
  <p>Here is a sample of what a form would look like in the 3 different evironments:</p>
  
  <pre><code>  Customers: DEV
  </code></pre>
  
  <p>//////////</p>
  
  <pre><code>  Customers: TEST
  </code></pre>
  
  <p>/////////</p>
  
  <pre><code>  Customers: PRODUCTION
  </code></pre>