[AccessD] How to Skip the Printing of a Subtotal if the Amount is Zero

Hi Brad

You should be able to specify the Format property for the textbox displaying the value. 
The format strings may add up to four sections covering all possible values: 

  FormatForPositives,FormatForNegatives,FormatForZero,FormatForNull

Thus, for a blank zero: 

  0,-0,Null

or, say: 

  #.00,-#.00,"","-"

/gustav


>>> BradM at blackforestltd.com 28-10-2010 04:59 >>>
Access 2007 Report

I would like to find an easy way to bypass the displaying of subtotals if they are zero.  The report detail lines still need to be shown.  In some cases, there are "offsetting" detail lines and a sub-total of zero is not wanted.  

Thanks,
Brad