title: MS Access invalid syntax
body: <p>In Access 2007 The code below gives Error 2434: The expression you entered contains invalid syntax.</p>
  
  <pre><code>  If (Eval("DLookUp(""[BaseRate]"",""RATELOOKUP"",""|DatePart(""yyyy"",[TxDate])| &amp; |DatePart(""m"",[TxDate])| = [RATELOOKUP].[PERIOD]"") Is Null")) Then
          ' Checks for Current Base Rate
          Beep
          MsgBox "Interest Rate required for this month", vbExclamation, ""
      End If
  </code></pre>
  
  <p>The error appears to be in the first line.</p>