Automating txtDate_Diff

[ROBERT SAMUELS]

Hi all,

I'm trying to get a text box to respond dynamically when a form is opened or
existing records are retrieved. The text box is concerned with date diff
calculations. In short there are 3 text boxes. The first "txtDelivery_date"
the 2nd "txtActual_date" the 3rd "txtDate_diff" is where the calculation
takes place. Inputting the dates and calcualting the date diff is not a
problem. If the "txtActual_date" is greater than "txtDelivery_date" the
"txtDate_Diff" control changes to red and displays a value.

The problem I've found is that when I enter an existing record the
"txtDate_Diff" control doesn't respond unless tabbed into.

Can anyone make any suggestions as to how I may be able to automate the
"txtDate_Diff" control so it responds dynamically to records retrieved.

Regards

Robert

 

[Rick B]

What kind of field is it and how does it do it's calculation?

If it is an unbound text box with a formula in it, then it will work as you
ask. If you are somehow using code to perform your calculation, then you
may have to put that code in the form's "current" event.

Personally, I would make it an unbound text box and put a formula in it.