I am using Access 2003 and on a form I have the Microsoft Date and Time
Picker Control 6.0 (SP4). But it when I enter the data from the form to the
table the time is with it, and that is causing it to error out. I tried to
make the DTPicker a custom Data and Time MM/dd/yyyy and just left out the
time part but it still adds in the time. Is there a custom format that will
not add in the time or another tools that is similar to this without the
time. I like this one because of the format.

If I want the date only without the time, I tend to use the Calendar Control
rather than the DTP ...

If you want to use the DTP, I think you can set its default time value to
zero ... In the design view of your Form, right-click on the DTP Control and
select DTP Object / Properties ... Some where on this dialog, you should see
the Time value. Change this value to 00:00:00 (a date-only value is actually
stored as a datetime value with zero time component). You can also use code
to set the "starting" value of the DTP to date-only value.

Of course, you need to check your code and make sure you don't assign a
non-zero time value to the DTP or your Field ...

--
HTH
Van T. Dinh
MVP (Access)



"dustinl15" <(E-Mail Removed)> wrote in message
news:FF4519F1-7D10-4C51-96A6-(E-Mail Removed)...
>I am using Access 2003 and on a form I have the Microsoft Date and Time
> Picker Control 6.0 (SP4). But it when I enter the data from the form to
> the
> table the time is with it, and that is causing it to error out. I tried
> to
> make the DTPicker a custom Data and Time MM/dd/yyyy and just left out
> the
> time part but it still adds in the time. Is there a custom format that
> will
> not add in the time or another tools that is similar to this without the
> time. I like this one because of the format.