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).
- Are you saying that times other than midnight are not showing?
- 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:
Posting Komentar