title: Concatenate 2 fields in textbox
body: <p>I'm trying to concatenate 2 fields from my database in 1 textbox like I did many times before setting the record source like this <code>=[parent] &amp; " - " &amp; [parentCity]</code>.</p>
  
  <p>It doesn't work.Instead, it writes #type! in the textbox. </p>
  
  <p>If I choose in the record source <code>parent</code> or <code>parentCity</code> separately it works.</p>
  
  <p>Also, no control are named <code>parent</code> or <code>parentCity</code> and 
  both fields are <code>varchar</code></p>
  
  <p>Then I thought it was because of <code>null</code> so I did something ugly like this </p>
  
  <pre><code>=IIf(IsNull([parent]),"",IIf(IsNull([parentCity]),[parent],[parent] &amp; [parentCity]))
  </code></pre>
  
  <p>I get the same error and i tried </p>
  
  <p><code>=IIf(IsNull([parent]),"",IIf(IsNull([parentCity]),[parent],"LOL"))</code></p>
  
  <p>And it works so the problem is definitively <code>[parent] &amp; " - " &amp; [parentCity]</code></p>
  
  <p>Does anyone know what's wrong here. </p>
  
  <p>Thank you</p>