Here is a simpler Access form that does the same thing and will work in all
versions of Access (with conversion). The Date Picker control does not work
in Access 2010:
http://www.datastrat.com/Download/Calendar2K.zip
This one uses less resource too, so you're ahead there as well.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com
"Olly" wrote in message
...
At the moment the user needs to click the textbox, and then on the
datepicker symbol to open the datepicker control. I am looking for a
way to open the datepicker automatically when the user enters into the
textbox, either through clicking on it or entering during the tab
cycle.
For example to open a combo box when the user's cursor enters it you
use "Screen.ActiveControl.Dropdown" in a function that is called from
the form objects "onenter" method. I'm looking for something similar
for the datepicker control.
cheers
Olly