Customise Control Error message

  • Thread starter Thread starter Kenny Kepler
  • Start date Start date
K

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
 
For the control source of the Price control, put something like this:

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