Problem with LEAVE of a datetime field

[Steve]

C#

I have a datetime field, when I leave this field I am trying to call some
validation on the date enered, namely that the date cant be ahead of today.

My validation checks the date entered against todays date. If the user
types the following in:

07/9/2005

then this fails. If she includes the extra zero:

07/09/2005, its fine.

I have debugged and stepped into the Leave trigger and for some reason at
the top of the leave trigger the date is not set correctly the first time it
runs, but the second time it runs it is ok! Its like the Leave trigger is
firing too early for me to validte the date on as it hasnt put in the extra
zero for me the first pass through.

Any one experienced this? Is there a event that fires after leave? If you
type in 07/9/2005 then tab out, it will correct itself and show as
07/09/2005, but this doesnt seem to occur until after the LEAVE trigger has
fired.

Thanks

Steve

[Cor Ligthert [MVP]]

Steve,

Be aware that the date you give can have more meanings in the different
culture settings no I assume it is the seventh of september. However am I
right when I assume that you have binded this textbox to a datatable.column
which has as type datetime?

The event to validate is of course validate, (as I assume that you mean with
trigger an event).

I see that nowhere in your text.

Cor