Date and Time Picker

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi

Iam using the Date and Time picker to allow users to selct a date, however
it goes into the database as the date selected and the current time, I only
want the date to go into the database. I have set the format as dd/MM/yyyy.
Is there any way of stopping it adding the time in aswell

Thanks
Fiachra
 
Setting the Format on the field or textbox will only make the item display
the way the format is set, not change the value of the underlying data. I
would first look at the date/time picker you're using to see if it has an
option to return only the value you want. If that won't work, then in the
AfterUpdate event of the textbox, try something like:

Me.txtMyTextbox = DateValue("#" & Me.txtMyTextbox & "#")
 
Fiachra,
Somewhere in your Date & Time picker code, it is concatenating
(combining) the Date and Time before updating your Date field. Find that
code, and remove the Time element.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

date time picker 1
Access 2003 - Date Picker Function 1
datetime picker 1
ActiveX control - Date/Time picker 2
date time picker on the tab control sub form 1
Set date to Date and time picker 1
Date Time Picker 4
Date Time Picker (MSComCtl2.DTPicker.2) 1

Back
Top