Text Box Formula in a report

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Dabears70 - 30 Jan 2007 16:23 GMT

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?

Signature

Nick

Reply to this Message

Jeff Boyce - 30 Jan 2007 17:00 GMT

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

> Is there a way to create a default value for a calculation in a text box.
> For
[quoted text clipped - 3 lines]
>
> Is there a way to make this default to zero? If so, how would I do that?

Reply to this Message