I have a calculation in one of my fields in a form. What is does is pulls two different currency numbers from two different fields, and then puts the percentage of difference in the calculated field. It works fine, but I need the option of putting text in the one field. When I do this I get an #error message. I went back into the table and changed the property to text, but then the calculation doesn't work. Is there a way to change the #error message to show nothing? If you have any other ideas please let me know. Thank you.

...but I need the option of putting text in the one field. When I do this I get an #error message. I went back into the table and changed the property to text, but then the calculation doesn't work. Is there a way to change the #error message to show nothing?
Could you provide some additional details? Which one of the fields do you have to put text into and why? Are these Currency Fields in the Table/Query? What sort of text? Which field show #Error?