Show $0.00 for blank Controlsource Field from Subreport

Posted on 2009-04-22
Last Modified: 2013-11-28
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]
Question by:BSAS_ITGuy
    LVL 13

    Accepted Solution

    =IIF(isnull([price total]),"$0.00")


    =NZ([price total],"$0.00")
    LVL 1

    Author Comment

    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.
    LVL 13

    Assisted Solution

    you could change the price that you are totaling to:


    then there would never be nulls to total, only zeros.
    LVL 1

    Author Comment

    LVL 1

    Author Closing Comment

    Quick responses.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    In the article entitled Working with Objects – Part 1 (, you learned the basics of working with objects, properties, methods, and events. In Work…
    Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
    In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
    In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now