Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

The time data that you enter in an Access 2010 form control displays the date 1/1/1900 on an Access 2010 client

View products that this article applies to.


You enter a time only value in a Microsoft Access 2010 form control on an Access 2010 client. When you view the date part of the date/time value on the client, the date part of the value shows the date of 1/1/1900. If you publish the form to the server, the date part shows the current system date.

For example, you enter the following value in a form control:
"11:00:00 AM"
This results in the date/time value on the client displaying the following date and time:
1/1/1900 11:00 AM
After you publish the form to the server, the date/time value displays a date that resembles the following. This example uses the date of 4/22/2010 as the current system date on the server.
4/22/2010 11:00 AM

↑ Back to the top


Microsoft has confirmed that this is a bug in the Microsoft products that are listed in the "Applies to" section.

↑ Back to the top

Keywords: KB981239, kbprb, kbsurveynew, kbtshoot, kbexpertiseinter, kbcontrol

↑ Back to the top

Article Info
Article ID : 981239
Revision : 4
Created on : 9/17/2011
Published on : 9/17/2011
Exists online : False
Views : 360