Calculation of Dates

  • Thread starter Thread starter KaiTi Yen
  • Start date Start date
K

KaiTi Yen

I have created a form with the calculation field. The
value of this calculation field comes from two date
fields. This is the data entry form, so if I did not set
up the value in those two fileds that need to be
calculated in the beginning, I got error message. So I set
up those two fileds to Today's date. But the user does
not like today's date on it. How and what shoud I do to
avoid the error message? Please help. Thanks.

KaiTi Yen
 
Default them to zero. Or to 1/1/1800 :-)
You can also turn the calculation off until the date controls become
Dirty, which means that the user started entering data (check Dirty
property), or turn the calculation on in AfterUpdate event of the date controls.
Pavel
 
Back
Top