Remove #Error in Access 2007

I want to remove the #ERROR from displaying in a field if the underlying data is null.  Is there a newer better way than an IIF and isnull?
vmccuneAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

JornakCommented:
Nz([field], [value if null])
will do the same thing.
Jeffrey CoachmanMIS LiasonCommented:
If this is based on a Function, declare the (missing) argument as a "Variant"
vmccuneAuthor Commented:
=nz([frmPrePlan20Buy].[Form]![sCYmDMDDOLLARS],Null)
=nz([frmPrePlan20Buy].[Form]![sCYmDMDDOLLARS],0)

both of these have no effect.
Your Guide to Achieving IT Business Success

The IT Service Excellence Tool Kit has best practices to keep your clients happy and business booming. Inside, you’ll find everything you need to increase client satisfaction and retention, become more competitive, and increase your overall success.

vmccuneAuthor Commented:
not based on a function.  Just a total field from a datasheet.
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
Not sure where/how your using this, but IsNull won't work because with #Error, nothing is returned.

In some cases, you can get away with IsError(), but I've always used AvoidError() (see the following):

http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_26219691.html#a32865042

  You can also depending on the situation, use IIF() to check for a record count and if 0, display something else.

Jim.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Jim Dettman (Microsoft MVP/ EE MVE)President / OwnerCommented:
BTW, if you want to know some nitty gritty details, check out this old thread:

http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_24272099.html

Jim.
vmccuneAuthor Commented:
ISError will get my by on this but the avoidError is very interesting.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.