title: ms-access If Else statement in VBA
body: <p>I keep on getting a syntax error when trying to run this on a VBA code in ms access. any thoughts why?</p>
  
  <pre><code>if (WBC_HFM_Application_Table.SETTLEMENT_DATE Is Null) Then 'No' Else 'Yes' as Funded 
  </code></pre>
  
  <p>I tried to put "End If" at the end and also tried again before 'as' word but no luck. </p>