title: Converting Yes/No field to string in MS Access Report
body: <p>I have a field in my query, <code>[Metrics].[Aligned]</code>, which is <code>Yes/No</code>. I need it to show up on my report as one of two strings depending on if it is true or false. I have the following expression to do that:</p>
  
  <p><code>Alignment: CStr(IIf([Metrics].[Aligned],"Aligned Metrics","Non-Aligned Metrics"))</code></p>
  
  <p>But when I go to create a report from this query, it still shows up as a <code>Yes/No</code> checkbox. Any suggestions?</p>