Access Reports - Do Not Display If Result = zero

Posted on 2005-03-21
Medium Priority
Last Modified: 2013-11-28
I have an access report that lists various values.  However, I don't want to print 0.00 where the value = zero.  

Is this possible?

Question by:Lapchien
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
LVL 58

Expert Comment

ID: 13590432
Use the format property to change the displayed value for zero values. It can have up to four sections delimited by semi-colons

Form Access help on the property:

Section      Description
First      The format for positive numbers.
Second      The format for negative numbers.
Third      The format for zero values.
Fourth      The format for Null values.

So use: 0.00;;''


Author Comment

ID: 13590470
Maybe you've missunderstood!  Where my eport currently gives:

10.43    11.33    2.45    0.00    0.00    34.56

I would like the following displayed on the report:

10.43    11.33    2.45                        34.56


LVL 58

Accepted Solution

harfang earned 2000 total points
ID: 13590507
Well, set the format as I suggested and that is what you will get :)
i.e. select the row of controls and type this into the format property: 0.00;;""

Good Luck!

Author Comment

ID: 13590551
Nice one, cheers.

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Suggested Courses

777 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