title: MSACCESS Is there a way for a query with a Boolean field to echo the string representation of the Boolean without taking way it's boolean type?
body: <p>Is there a way in a query for Microsoft Access to have a field that tests likeness of two fields and return the string representation of "True" or "False" instead of a -1 or 0 without loosing the boolean type?</p>
  
  <pre><code> SQL SYNTAX
   [Table1].[Field1]=[Table2].[Field1] AS Compare
  </code></pre>
  
  <p>I would like it to be easy something like </p>
  
  <pre><code> Cstr([Table1].[Field1]=[Table2].[Field1])
  </code></pre>
  
  <p>Although I know I could just write a function in VBA to achieve the same effect I'm wondering if there is already a way to represent a Boolean with it's string value without taking away the Boolean nature from it's type. </p>
  
  <p>And I also want to avoid doing</p>
  
  <pre><code> iff([Table1].[Field1]=[Table2].[Field1], "True", "False") 
  </code></pre>
  
  <p>As although it will visually do the job, it will mean that I will have to make any programmatic comparisons look for the string value of "True" "true" "TRUE"... instead of it's intended function as a yes/no in the first place. </p>
  
  <p>I mainly find this a minor annoyance since in the intermediate window of VBA I can clearly see the string value like this</p>
  
  <pre><code> debug.? "a"="a"
   True
  </code></pre>
  
  <p>And I don't get why it's not consistent.</p>