Suppress zero print

[Ham]

I have an Acces Report where I want to print a blank when a field value is zero. The value comes from an Access table where it is defined as an integer.

I have the following statement in the control source for that field of the report:

=iif([Number]=0," ",[Number])

I have also tried: =iif(IsNull([Number])," ",[Number]).

In either case the zeros print. How can I suppress that print?

Thanks. -- Ham Rutledge

 

[PHV]

Set the Format property of the [Number] control to something like this:
0;-0;"";""

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[Ham]

That did the trick! Many thanks for your help. -- Ham