I would actually use Clifford's suggestion since it doesn't involve changing
the Control Source.
However, I would change:
=IIf(IsNull([YourField]),"0",[YourField])
to
=IIf(IsNull([YourField]),0,[YourField])
I try to keep the proper data type and "0" is a string which doesn't make
sense.
You could also use the simpler:
=Nz([YourField],0)
or
=Val(Nz([YourField],0))
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.