Text Box Formula in a report

D

Dabears70

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?
 
J

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

No text box in word 2016 0
Link a text box based on drop down box with four options MS Word 365 0
Clearing combo boxes and a text box 2
Possible to Combine reports to's to a single box? 0
Creating a Search using a combo box and then creating a report. 4
Centered text that does not stay centered 0
Template with fields and premade texts.. 0
Word OLE to check spelling in text box 1

Top