I have one field named "Date_Capture" created on the access form which is available for end user to select the date by using date picker. When user is selecting the date using date picker then only date is coming correct but the correct time is not showing up. for each record time is coming like 11/10/2015 12:00:00 AM, 11//11/2016 12:00:00 AM.I need to show the exact time when we select a particular date using date picker.

is there any work around to fix this? Please let me know.

Thanks, RR

In response to Thomas G and RRO, put this code into the Code Builder for one of the Date fields, After Update Function.

Dim X As String

X = Format (Now(), "hh:mm:ss")

Me!YourFieldName.Value = X

more