I have a datetime field with Deafult value set on the textbox as Date(). When the user changes this it is cleared and the user must enter all the date details. What the users want is to be able to change partof the default date such as the day or month. This works fine on an mdb but I cant get it to work on adp. Any ideas. I have tried setting the default value of the field in the table to Date() but it will not accept this.