Don't show #Error

[Emmweb]

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

 

[Dennis]

Try putting an iif on the field
=IIf(IsError(Yourformula),Null,Yourformula)

 

[Emmweb]

Perfect! Thanks so much,
erin