Make formula return '0' instead of 'Error'

[RogerC]

I have a text box on a report that has =Count([REJECTS]) in its control source. Sometimes the reult of the count will be 0. Is there a way to make the text box show '0' instead of 'Error' when the count = 0?

 

[Gates Is Antichrist]

Change it to this

=DCount("*","[REJECTS]",True)