Calculation of Dates

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
 
P

Pavel Romashkin

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to display calculated fields instead of storage 13
dafault value for date not working with Date() but Now() is workin 3
Calculation 2
Date Calculation problem 11
Days left for impact 3
Can I calculate from unbound text boxes? 1
Update table with future date calculated in form 5
data calculated in form field not showing up on table datasheet 2

Top