<div>
For some strange reason whenever I put that expression it kicks me out os Access, blinks and then sends me back in with the old formula still there.
</div>


For some strange reason whenever I put that expression it kicks me out os Access, blinks and then sends me back in with the old formula still there.

<div>
<div class="content wysiwyg-content">
I have an access form that is pulling a sum from the subreport. I want to show $0.00 for any time the controlsource is null or blank from the subreport. Right now it returns #error whenever ther is no data. I would like to show $0.00 in that case.<br />
<br />
&nbsp;I currently have this as the controlsource: &nbsp;=Details.Form![price total]
</div>
</div>


I have an access form that is pulling a sum from the subreport. I want to show $0.00 for any time the controlsource is null or blank from the subreport. Right now it returns #error whenever ther is no data. I would like to show $0.00 in that case.

 I currently have this as the controlsource:  =Details.Form![price total]

Show $0.00 for blank Controlsource Field from Subreport

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.