<div>
Where would this go exactly? &nbsp;Is it added to the control source?
</div>


Where would this go exactly?  Is it added to the control source?

<div>
You can add a new, unbound, Textbox control to your report and enter the expression as the ControlSource.<br />
OM Gang
</div>


You can add a new, unbound, Textbox control to your report and enter the expression as the ControlSource.
OM Gang

<div>
I think I actually just need to replace the control source that was there. &nbsp;Thanks 
</div>


I think I actually just need to replace the control source that was there.  Thanks

<div>
<div class="content wysiwyg-content">
I have a report that displays zero if the value is zero. &nbsp;OK, but now I need to display the zero as N/A instead of zero. &nbsp;How do I do this? &nbsp;One text box I have has this code as the control source.<br />
<br />
=IIf([AskPrice]&gt;0,[AskPric<wbr />e],&quot;&quot;)<br />
<br />
Thanks<br />
<br />

</div>
</div>


I have a report that displays zero if the value is zero.  OK, but now I need to display the zero as N/A instead of zero.  How do I do this?  One text box I have has this code as the control source.

=IIf([AskPrice]>0,[AskPrice],"")

Thanks



How to make an alias for zero on a report only

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.