title: VBA Access 2016 IDE capitalising object property
body: <p>I'm working with a block of code in VBA (Access 2016) to get the status of a MailChimp contact via their API:</p>
  
  <pre><code>With CreateObject("MSXML2.ServerXMLHTTP")
      .Open Request, APIUrl &amp; APIString &amp; Criteria, False
      .setrequestheader "Authorization", "Basic " &amp; APIAuth
      .send
      APIResponse = .responsetext
      If InStr(APIResponse, "{""exact_matches"":{""members"":[]") &gt; 0 Then
          MailExist = False
          Else
          MailExist = True
          Set JSONControl = CreateObject("MSScriptControl.ScriptControl")
          JSONControl.language = "Jscript"
          APIString = "XXXXXXX"
          .Open Request, APIUrl &amp; APIString &amp; Criteria, False
          .setrequestheader "Authorization", "Basic " &amp; APIAuth
          .send
          Set Subber = JSONControl.Eval("(" + .responsetext + ")")
          If Subber.status = "subscribed" Then
              MailSub = True
              Else
              MailSub = False
          End If
      End If
  End With
  </code></pre>
  
  <p>Towards the end I use the 'Subber' object to see if the contact is subscribed or not</p>
  
  <p><strong>If Subber.status = "subscribed" Then</strong></p>
  
  <p>This has been working fine until recently, when the 'status' Property is suddenly being capitalised by the IDE, causing it to error out with an 'Object does not support this property or method' message.</p>
  
  <p>I've done some digging and found a similar problem with a solution <a href="https://stackoverflow.com/questions/8835553/vba-excel-2010-editor-capitalizes-property-name-and-it-cannot-be-accessed">here</a>, but after following the solutions the 'status' is still being capitalised. I've tried checking through the whole project for the word 'Status' with no results, and none of the controls on my forms use it either. I did have a table field with the name 'Status' but I've since renamed that so it shouldn't affect it, and I've also tried setting a public variable called 'status'. This worked to set the property back to all lowercase, but once the code is triggered the property goes back to 'Status', along with the variable name. I'm now stuck and can't figure out why the capitalisation occurs!</p>