Suppressing Zeros

[warpped]

I have a complex report in Access 2000 with several unbound text boxes that are set up as fixed, 2 decimal places. The values are loaded with code. When the value is zero, the box shows 0.00. Is there any way, other than code, to suppress the zeros and display a blank box?

Thanks

 

[JoeMiller]

Change the format on the text box. The format command has 4 parts, each separated by a ;

FormatForPositiveNumbers;FormatForNegativeNumbers;FormatForZeroValues;FormatForNullValues

So something like this might work for you:

0.0;0.0;"";"Null"

HTH Joe Miller
joe.miller@flotech.net

 

[warpped]

Thank you. This is exactly what I needed.