title: Using the Can Shrink option for Currency
body: <p>I am creating a report in Microsoft Access 2019.</p>
  
  <p>Using the code: <code>=IIf(Trim(Nz([TextBox],""))="","","TextBox")</code>, I have been able to use the can shrink option to save space, and make the report easier to read.  Using this and similar codes, I have been able to shrink text boxes, dates, and check boxes.</p>
  
  <p>I am having trouble with currency though.  Since the currency boxes are already filled as $0.00, I can't use the code above.  </p>
  
  <p>When I tried these two codes: <code>=IIf(Trim(Nz([Base Cost],"$0.00"))="","","Base Cost")</code> or <code>=IIf(Trim(Nz([Base Cost],""))="$0.00","","Base Cost")</code> I got an error saying "The control has a reference to itself"</p>
  
  <p>Along the same lines, how would I code the unbound box label for the Currency if I want it to shrink.</p>
  
  <p>In Essence: I have two boxes:  Base Cost and $0.00.  I'm having trouble figuring out an If/Then statement for the currency to display ONLY if it has value greater than 0.  Then how would I code the Base Cost label to display ONLY if the currency if greater than 0.</p>
  
  <p>Thanks.</p>