Date and Time Record always shows as 12:00AM

[Ali Omran]

Hello

i am currently using a form with Date and Time field, whenever someone clicks (Today) to record "Today's date and time" the time seems to work only on 12:00AM :banghead:.

is this an issue with MS Access or some settings i need to fix

 

[CJ_London]

date and time are stored as a number - they are formatted to look like dates you are used to seeing - so I would check what format you are using

 

[cyanidem]

Problem lays perhaps in how date picker in date/time fields works. When you click Today it inserts today's date at midnight. So if you want to record current time exactly you need to create custom button and use Now() function instead.

 

[Ali Omran]

The Data Type is date and format and on the form, the format is general format (Suppose to store both date and time)

 

[missinglinq]

the format is general format (Suppose to store both date and time)

It is storing both both Date and Time...but the DatePicker only inserts the Date, and the Time that is stored, when no Time is specified, in a Date/Time Field, is midnight!

As cyanidem said, you'll need to use the Now() function to record the current Date and Time! If you don't want to use a Command Button, you can simply use the code in the Double-Click event of the Textbox.

Linq ;0)>

 

[Ali Omran]

It is storing both both Date and Time...but the DatePicker only inserts the Date, and the Time that is stored, when no Time is specified, in a Date/Time Field, is midnight!

As cyanidem said, you'll need to use the Now() function to record the current Date and Time! If you don't want to use a Command Button, you can simply use the code in the Double-Click event of the Textbox.

Linq ;0)>

thanks

thats what i did, i created a command button, and i write this

"Field name".Value = Now()

which now records the time if i click on the button

 

[missinglinq]

Glad we could help!

Good luck with your project!

Linq ;0)>