title: ***** instead of truncating a field in Crystal Reports
body: <p>I was wondering if there was a way in Crystal to do the following:</p>
  
  <p>If a field has a character limit of 10 characters...and the data fed in has 11 characters, instead of showing truncated data, i'd like it to show **** .  Excel has a function like this where if a column is too narrow for a field to show completely, it shows ###### instead of the data.</p>
  
  <p>Is there a way to do this for numeric fields and string fields?</p>
  
  <p>I have tried:  </p>
  
  <pre><code>if length {DataTable1.Name} &lt; 4 then {DataTable1.Name} else '****'
  </code></pre>
  
  <p>also,</p>
  
  <pre><code>if length {DataTable1.Name} &gt; 4 then '*****'
  </code></pre>
  
  <p>Neither works.  Any ideas?</p>