Displaying zero in report.

[srdawson]

First post so please bear with me.
I am trying to display zeros in a report and at present I'm getting blank in text box where the value is zero.
How do I display zero?

 

[plog]

Set the control source to ="0"

That will definitely do it, but not how you want. It sounds like your issue is a query issue not a report issue. You need to investigate the underlying query, identify a specific record that has a null value and then find out why that is null.

You can use the NZ function (http://www.techonthenet.com/access/functions/advanced/nz.php) to force some null values to 0.

 

[srdawson]

That will definitely do it, but not how you want. It sounds like your issue is a query issue not a report issue. You need to investigate the underlying query, identify a specific record that has a null value and then find out why that is null.

I've checked the query and there are no Null values. All records contain either a number or 0!

 

[plog]

So what is currently the control source of the text box that is displaying the blanks? Can you post your database as a zip?

 

[srdawson]

So what is currently the control source of the text box that is displaying the blanks? Can you post your database as a zip?

The control sources of the text boxes are the fields in the underlying query.

 

[pbaldy]

What is the Format property of the textbox? If you used the 4 part syntax, the 0 could be suppressed there.

 

[srdawson]

What is the Format property of the textbox? If you used the 4 part syntax, the 0 could be suppressed there.

General Number

Trying to attach a zip file with extract of db but never done this before so be patient.


Ah! need to have 10 posts or more to attach file! Only have 4.

 

[pbaldy]

Hmm, I thought it was going to be hidden there. Any code running, or perhaps something in Conditional Formatting that would affect zeros? Can you post the db here?

 

[srdawson]

OK, I've just deleted the Text boxes then recreated them in what I thought was the exact same way as I did originally.
Now the zeros are visible? A mystery to me!

 

[pbaldy]

Strange; glad you got it sorted out.