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: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Tuesday, February 02, 2016 1:52 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: RE: [MS_AccessPros] Re: general date format

 



Liz

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

-Bill



---In MS_Access_Professionals@yahoogroups.com, <liz_ravenwood@beaerospace.com> 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: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Tuesday, February 02, 2016 12:24 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Re: general date format

 



Liz

 

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?

Regards,

Bill Mosca, Founder - MS_Access_Professionals

Microsoft Office Access MVP

My nothing-to-do-with-Access blog

 



---In MS_Access_Professionals@yahoogroups.com, <liz_ravenwood@beaerospace.com> 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?

 

Respectfully,

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 <Liz_Ravenwood@beaerospace.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (5)

.

__,_._,___

Tidak ada komentar:

Poskan Komentar