Selasa, 02 Februari 2016

RE: [MS_AccessPros] Re: general date format


Of course, and that is funny.  I can view it in datasheet view and it is the same – date only – no time.  I was in a meeting so am ready to try my experiment.


From: []
Sent: Tuesday, February 02, 2016 1:52 PM
Subject: RE: [MS_AccessPros] Re: general date format



Have you tried widening the control to see if the time is just hidden?


---In, <> wrote :

Hi Bill,  It just shows the date.  I checked the table and there wasn't a format on it.  I don't like to set things at that level – rather at the form level for flexibility.  I'm going to try a couple of things.  1.  Add the fields to the form again, and 2. If that doesn't work, I'll try new fields.



From: []
Sent: Tuesday, February 02, 2016 12:24 PM
Subject: [MS_AccessPros] Re: general date format




Access doesn't show a time if it's midnight (00:00 the default for any given date). 

  1. Are you saying that times other than midnight are not showing?
  2. Does the field in the table have a format on it?


Bill Mosca, Founder - MS_Access_Professionals

Microsoft Office Access MVP

My nothing-to-do-with-Access blog


---In, <> wrote :

Pros, I recently changed a form format from short time to general date and it is not showing me the time.

What am I doing wrong?  What simple thing have I possibly missed?



Liz Ravenwood

Programmer / Analyst

B/E Aerospace | Super First Class Environments



This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.


Posted by: Liz Ravenwood <>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (5)



Tidak ada komentar:

Posting Komentar