Bill, I think you got another MS Access bug you can report. I used the very same fields, went into form design, select fields, added those fields, went into datasheet view, and the new fields show time and the old fields don't.
I'll swap them out. I think it locked on to some short time value as a previous value or something.
Problem solved. Thanks.
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Tuesday, February 02, 2016 2:13 PM
To: 'MS_Access_Professionals@yahoogroups.com'
Subject: 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).
- 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.
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 (6) |
Tidak ada komentar:
Posting Komentar