Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


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
  • 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

Technology Partners: 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

Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
Sometimes MS breaks things just for fun... In Access 2003, only the maximum allowable SQL string length could cause problems as you built a recordset. Now, when using string data in a WHERE clause, the 'identifier' maximum is 128 characters. So, …
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
Suggested Courses

580 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