Text Box Formula in a report

[Guest]

Is there a way to create a default value for a calculation in a text box. For
example in our database a percentage is derived by dividing two different
numbers, but if one of the values is zero then a error pops up saying "#Num!".

Is there a way to make this default to zero? If so, how would I do that?

 

[Jeff Boyce]

Nick

Modify the formula/calculation to include handling the Div/0 and other error
conditions.

You could use the IIF() statement in your source, something like:
=IIF(...

Regards

Jeff Boyce
Microsoft Office/Access MVP