This is a good one, Allen, thanks! I didn't think to use code to force the
button to show for the date picker. I have an issue where, if I use a date
input mask, the date picker button won't show, so doing a got focus event
might be just the ticket. I'd get rid of the input mask, however, some users
do use that option, and would most likely complain if I removed it.
Andy
"Allen Browne" <AllenBrowne@SeeSig.Invalidwrote in message
news:4734526f$0$23950$5a62ac22@per-qv1-newsreader-01.iinet.net.au...
Quote:
>I don't see a built-in shortcut for the date picker.
>
You could create an AutoKeys macro, and assign a keystroke to RunCommand
with ShowDatePicker.
>
Alternatively, if you want this for one date box on one form, you could
add a shortcut key to SetFocus to the date field, and then RunCommand
acCmdShowDatePicker
>
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users -
http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
>
"Alfred" <adminnaar@gmail.comwrote in message
news:n-mdnd3LCa6u2anaRVnyvQA@saix.net...
Quote:
>HI
>Using Access 2007
>Can I open the calendar that automatically appears next to date fields
>with a keyboard shortcut as I dont want to use the mouse
>Thanks
>Alfred
>