Customise Control Error message

[Kenny Kepler]

Hello,

I have a Price control on a form that gets it's value as the product of the
values in other fields. But until I enter a value into all the other fields
I get a "#Error" in my Price control. The only way I can find to get rid of
this thing is to set a default value for the other fields. This isn't
exactly desirable. I would prefer that the value was blank and the "#Error"
didn't appear.

Could someone please tell me how to do this?

Thank you,

Kenny

 

[Treebeard]

For the control source of the Price control, put something like this:

=IIf(IsNumeric([Control1]) And
IsNumeric([Control2]),[Control1]*[Control2],0)