Microsoft KB Archive/825445

= Data remains unchanged when you modify dates by using the Calendar Control =

Article ID: 825445

Article Last Modified on 6/8/2004

-

APPLIES TO


 * Microsoft Office Access 2003

-



Moderate: Requires basic macro, coding, and interoperability skills. This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).



For a Microsoft Access 2002 version of this article, see 294198.



For a Microsoft Access 2000 version of this article, see 225982.



SYMPTOMS
When you select a date on the Calendar control, the date is not updated in the field that is specified in the ControlSource property of the Calendar control.



CAUSE
The Calendar control does not update the field that is specified in the ControlSource property of the Calendar control until you either move the focus to another control or save the record.



WORKAROUND
To work around this problem, use either of the following methods:
 * Move the focus from the Calendar control to another control.
 * Save the record after you update the Calendar control by clicking Save Record on the Records menu.



STATUS
Microsoft has confirmed that this is a bug in the Microsoft products that are listed at the beginning of this article.



Steps to Reproduce the Problem

 * 1) Start Access.
 * 2) Open the Northwind.mdb sample database.
 * 3) Create a new form that is based on the Orders table.
 * 4) On the Insert menu, click ActiveX Controls.
 * 5) In the Insert ActiveX Control dialog box, click Calendar Control 11.0, and then click OK.
 * 6) On the View menu, click Properties if you cannot see the property sheet for the Calendar control.
 * 7) Change the ControlSource property of the Calendar control to OrderDate.
 * 8) On the View menu, click Field List if you cannot see the field list.
 * 9) In the Field list, move the OrderDate field to the form.

This creates a text box with OrderDate as the control source.
 * 1) On the View menu, click Form.

Notice that the Calendar control and the text box display the same date.
 * 1) Click multiple dates in the Calendar control.

Notice that your subsequent selections do not update the date value that is shown in the text box until you move the focus from the Calendar control by clicking in the text box.

Additional query words: Access2003

Keywords: kbbug KB825445

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.