title: ms access - option button value -1 when selected
body: <p>I have an option button that has a control source. The button is NOT part of an option group. When the button is not selected it stores 0 (which is what I want) however, when the option button is selected it stores -1 instead of 1. I cannot seem to find the property in the menu to set the option value.</p>
  
  <p>Is there a way to set the storage value when it is selected to 1 not -1?</p>
  
  <p>I tried Me.Controls("optionButtonControlName").OptionValue = 1 but I got an error.</p>
  
  <p>I know I could do: </p>
  
  <pre><code>If (optBtn.Value = -1) Then
      optBtn.Value = 1
  End If
  </code></pre>
  
  <p>Each time the button is clicked but there has to be an easier way to do this that I'm just not seeing.</p>
  
  <p>Thanks!</p>