Calendar in MS 2007

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

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...

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...

Okay, you have it sorted out.

There might be a reason why the MS Access team disabled the date picker when
input masks are used. I haven't tested, you probably want to check that it
interprets your mask correctly if the format is non-standard.

--
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.

"ARC" <PCESoft@PCESoft.invalidwrote in message
news:nEK_i.6858$TR5.5516@nlpi061.nbdc.sbc.com...

Thanks, Allen. The mask that I use most is: "99/99/0099;0;_"


"Allen Browne" <AllenBrowne@SeeSig.Invalidwrote in message
news:473b9167$0$10702$5a62ac22@per-qv1-newsreader-01.iinet.net.au...