Blank when zero on report detail?

  • Thread starter Thread starter Babette Olson
  • Start date Start date
B

Babette Olson

I have a subreport with details that are often zero.
Client wants them to be blank when zero.

There is math in both the query and the report.

Help Always Appreciated
 
well, you could unbind the report controls in question, changing the control
source to

=If(FieldName = 0, Null, FieldName)

changing FieldName to the name of the actual field from the underlying
query. also, make sure that the unbound control's name is not the same as
the fieldname - Access will not allow circular field references, except in
VBA.

hth
 
This sounds like something that you can use the conditional IF function for. Try adding a textbox
to the subreport. It is important that the name of a referenced field is not the same as the
name of the textbox, so name the textbox something like txtResult. For this example, I will
assume that the name of field (as shown in the field list) is MyResult. Enter the following
calculation into the ControlSource for this textbox:

= IIF([MyResult]<>0, [MyResult],"")


Here is information from the Access Help file on using the IIF function:

IIf Function
Returns one of two parts, depending on the evaluation of an expression.

Syntax

IIf(expr, truepart, falsepart)

The IIf function syntax has these named arguments:

Part Description
expr Required. Expression you want to evaluate.
truepart Required. Value or expression returned if expr is True.
falsepart Required. Value or expression returned if expr is False.



Remarks

IIf always evaluates both truepart and falsepart, even though it returns only one of them.
Because of this, you should watch for undesirable side effects. For example, if evaluating
falsepart results in a division by zero error, an error occurs even if expr is True.


Tom
______________________________________


I have a subreport with details that are often zero.
Client wants them to be blank when zero.

There is math in both the query and the report.

Help Always Appreciated
 
I have a subreport with details that are often zero.
Client wants them to be blank when zero.

There is math in both the query and the report.

Help Always Appreciated
Click to expand...

Set the Format property of the control to:
#;-#;""

See Access Help re:
Format Property + Numbers and Currency datatypes
 
Back
Top