[MS_AccessPros] How do I format a Date/Time field to display the actual time like 12/04/2013 11:20 AM instead of 12/04/2013 12:00:00 AM

 

Good morning

 

My table has a date/time field.In the Field Properties section, I set the format as mm/dd/yyyy hh:mm:ss AM/PM. What caused the time section of the DateTime field displays the time as 12:00:00 AM instead of the actual time?

 

Thank you

 

Phucon

__._,_.___

Reply via web post

Reply to sender

Reply to group

Start a New Topic

Messages in this topic (1)

Recent Activity:

• New Members 2

Visit Your Group

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use • Send us Feedback

.

__,_._,___