title: Clear fields from a form except 1 object (access VBA)
body: <p>I have a form in Access and i try to make a button that clears the total form.
  it works but not for 1 field because in the database that field has NOT NULL given to it.</p>
  
  <p>this is my form: <a href="https://i.stack.imgur.com/j7EOI.png" rel="nofollow noreferrer">http://i.stack.imgur.com/j7EOI.png</a></p>
  
  <p>When i pres on the button [Leeg Velden] 
  then this vba code will be running:</p>
  
  <pre><code>Private Sub btnLeegVelden_Click()
      Dim object As Object
  
      For Each object In Screen.ActiveForm
          If Name(object) = "ibvoorraad" Then
              Me.ibvoorraad.Value = "0"
          Else
  
              If TypeName(object) = "TextBox" Then object.Value = ""
          End If
      Next object
  
      btnArtikelToevoegen.Enabled = True
  End Sub
  </code></pre>
  
  <p>How can i add some code that will clear all the field but in the field "Voorraad" it needs to set it to 0 instead of empty.</p>