With Word 2007's new Date Picker control, you can make it easy for customers to enter dates in your forms. For example, suppose you create a Project Requirements form that lets customers list the requirements for their next system upgrade. You would like them to suggest the best times to start and finish the project. Follow these steps to add the corresponding Date Picker controls to your form:

1. Click where you want customers to enter the project start date in your form.
2. Type Project Start Date:.
3. Press [Tab].
4. Click the Developer tab. (If you don't see it, click the Office button, click Word Options, click Popular, and then select the Show Developer Tab In The Ribbon check box.)
5. Click the Date Picker control in the Controls group.
6. Click Properties in the Controls group.
7. Click in the Title text box and enter Start Date:.
8. In the Display The Date Like This list box, select the desired date format and then click OK.
9. Click to the right of the Date Picker control to deselect, and then press [Enter] twice.
10. Type Project End Date:.
11. Press [Tab].
12. Click the Developer tab.
13. Click the Date Picker Control in the Controls group.
14. Click Properties in the Controls group.
15. Click inside the Title text box and enter End Date:.
16. In the Display The Date Like This list box, select the desired date format and then click OK.
17. Click to the right of the Date Picker control to deselect.
18. Click the Protect Document command in the Protect group.
19. If you are using Microsoft Office Ultimate 2007, Office Professional Plus 2007, or Office Enterprise 2007, click Restrict Formatting And Editing. Otherwise, for other releases of Word 2007, skip to step 20.
20. In the Restrict Formatting And Editing pane, click the Allow Only This Type Of Editing in the Document check box.
21. Click the list arrow and select Filling In Forms.
22. Click the Yes, Start Enforcing Protection button and then click OK.
23. Click the Office button.
24. Click Save As.
25. From the Save As Type drop-down menu, click Word Template.
26. Click the Trusted Template folder on the left, enter the filename Project Requirements Form, and then click Save.

Hi, I am unable to find the Microsoft Date Picker in the ActiveX control list in Excel 2010. Is there a way I can get this? Many thanks, rjani5 Hello: CSharpNoob pointed to. “Calendar control (mscal.ocx) is removed in Access 2010 and is not usable for Excel 2010. Instead, users can use Date Picker or their own custom calendar controls.” So, we have tried Date Picker, and our experience is that it is not easy to use in existing applications. The property and event structure is different from the Calendar Control. Hi, I am unable to find the Microsoft Date Picker in the ActiveX control list in Excel 2010. Is there a way I can get this? Many thanks, rjani5 Hello: CSharpNoob pointed to some good articles. On my website, over 90% of my traffic goes to the one page for the date picker. I get about 2500 hits a month on the date picker page: Excel 2010 Date Picker.

To use the form, follow these steps:

1. Click the Office button and then click New.
2. Click My Templates from the list on the left.
3. Click the Project Requirements template under My templates tab.
4. Click OK.
5. Enter the information required by each control.
6. To enter the project start date as today's date, click the Project Start Date Picker control, click the drop-arrow, and click Today.
7. To enter the project end date for the end of next month, click the Project End Date Date Picker control, click the drop-down arrow, click the right arrow to display the next month, and then click 30.
8. Save and close the document.

Miss a Word tip?

Check out the Microsoft Word archive, and catch up on other Word tips. Installing python on windows 7.

Microsoft Date Picker Control Excel 2010

Help users increase productivity by automatically signing up for TechRepublic's free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.