Date Time Picker help

[Guest]

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.

 

[Van T. Dinh]

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 ...