>I have a Text box that has a control source that is a DateTime type. I want to display and allow to edit just the date. Is there any way to do this?
>
>The reason I am using a DateTime field is because my remote database only has a DateTime type for dates.

You may display it and edit, but with no Controlsource. Instead you will fire Thisform.Mytextbox.Value=ttod(mycursor.mydatetime) from some appropriate place (in oversimplified case this is Form.Refresh). When it comes to save you will Replace Mycursor.mydatetime With dtot(thisform.mytextbox.value)