DOCUMENT:Q125604 05-JUL-2002 [accother] TITLE :ADT2: Cannot Edit Fields in Form with Calendar Control PRODUCT :Microsoft Access Distribution Kit PROD/VER:WINDOWS:2.0 OPER/SYS: KEYWORDS:kbusage ====================================================================== ------------------------------------------------------------------------------- The information in this article applies to: - Microsoft Access Developer's Toolkit, version 2.0 ------------------------------------------------------------------------------- Moderate: Requires basic macro, coding, and interoperability skills. SYMPTOMS ======== When you select dates on your calendar custom control, the border around the selected dates alternates between a solid line and a faint dotted line. When the border is a faint dotted line, you cannot edit the fields on the form. (You may be able to delete characters, but you cannot add any). CAUSE ===== This problem can occur if the calendar control is located in the form's header section. RESOLUTION ========== Move the calendar control from the form's header section to the form's detail section. STATUS ====== Microsoft has confirmed this to be a problem in Microsoft Access version 2.0. This problem no longer occurs in Microsoft Access for Windows 95 version 7.0. MORE INFORMATION ================ Steps to Reproduce Problem -------------------------- 1. Open the sample database NWIND.MDB. 2. Create a blank new form based on the Orders table. 3. From the Edit menu, choose Insert Object. 4. In the Insert Object dialog box, select the Insert Control option button. In the Control Type box, select Calendar Control. Choose OK. 5. Add the Order Date and Customer ID fields to the detail section. 6. Set the calendar control's OnClick property to the following event procedure: Sub Embedded0_Click () DoCmd ShowAllRecords DoCmd ApplyFilter , "[Order Date] < #" & [embedded0].object & "#" End Sub 7. View the form in Form view. Select various dates on the calendar. Note that you can edit the Customer ID field after you select each date. 8. View the form in Design view. From the Format menu, choose Form Header/Footer. 9. Move the calendar control to the form header section. 10. View the form in Form view. Select various dates on the calendar. Note that you can edit the Customer ID field only after every other date selection and that the border around the selected dates alternates between a solid line and a faint dotted line. REFERENCES ========== Microsoft Access Developer's Toolkit "Advanced Topics," version 2.0, Chapter 6, "Using OLE Custom Controls," pages 163-175 Additional query words: ====================================================================== Keywords : kbusage Technology : kbAudDeveloper kbAccessSearch kbAccessDevTK200 kbZNotKeyword3 Version : WINDOWS:2.0 Hardware : x86 Issue type : kbbug ============================================================================= THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY. Copyright Microsoft Corporation 2002.