>Unbind the control from the date field and make it a character type by clearing the Value property. You could then put your code in the Valid() event. You would, of course, have to manualy validate that the entered date is valid and you will have to get/save the value from/to the field.
>
>HTH
>

I was hoping you wouldn't say that...but I'll look into that...might as well change the format for that table field from date to character...if anyone has any other suggestions please post:)

p.s. Thanks Sylvain:)