Don't show #Error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form in continuous view. The form has a formula field on it. For
existing records, the formula works just fine, but for the new record which
shows since it's a continuous view, the field shows "#Error."

Is there a way to not show the #Error for the new record...?
 
Try putting an iif on the field
=IIf(IsError(Yourformula),Null,Yourformula)
 
You must log in or register to reply here.

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

DMax on existing record to increment serialized # fails 1
Sub-form shows #Error for no data - how can I hide this? 1
Form/Subform “value isn't valid†3
Unremovable horizontal scroll bar on subform 1
Conditional marker on subform? 1
How to subtract a number from a Mergefield? 0
Continue Excel to New Uear 9
Hiding part of a Social Security Number 1

Back
Top