Allen Browne's Calendar

[PPCO]

Using Allen Browne's calendar. Wondering how I would get it to appear only
when the date field is clicked on, then disappear once a date is selected.
Also, how do I change it so a date is selected with a single-click and not a
double click. Thanks!

 

[Jeanette Cunningham]

Hi PPCO
the easiest way to hide and show the calendar is to use Aaaccess 2007 which
does this automatically without any code.

If that is not an option, you can use code to hide and show it.
Set the image or button or label with the calendar to visible = no on the
property sheet.
When the date field is clicked, your code does
Me.NameOfCalendarControl.Visible = True

In the exit or lost focus event of the date field, the code does
Me.NameOfCalendarControl.Visible = False

You can change the double click to a single click, by moving the code on the
double click event to the click event instead. You will need to look through
the code behind the calendar to find all the places to do this. In my
experience, the double click provides an easier way for users to choose a
date than a single click.

Note: replace NameOfCalendarControl with the real name of that control on
your form.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia