Date/Time field in Table only showing Date (1 Viewer)

[Laurad]

I need to show the exact date and time when records are added to a table. I've created a small table with 3 fields, one of which is DateEntered, Date/Time and the Format is General which should show the date AND the time. Unfortunately it's only showing the Date, both in the table and on a form where I have put a text box to show the Date/Time. What am I missing?
Thanks
Laura

 

[The_Doc_Man]

How did you fill the date/time field? Did you use "field = Date()" or "field = Now()"

A general date should include time, but not if you use Date() as the source.

 

[Laurad]

You're a star, thank you. It didn't occur to me to use Now() when populating the field, I did think Date() carried the Date and Time. Thanks for saving me time and effort, much appreciated. It works fine now.
Laura

 

[gemma-the-husky]

in passing, note also that time() gives the time without the date.

 

[Laurad]

Thank you, that's useful to know also. Dates and Times are powerful features and are quite complex. Grateful for the help