Hi Richard,

I have a form containing a calendar (MSCAL.Calendar.7). I also have a textbox on the form. When a user chooses a date it looks at the month chosen and displays in the textbox the users task for that month. The problem I have is if they select a new month from the monthly dropdown the calendar doesnt update until you click an actual date that month. So if July the 1st is selected and you drop down and change to September the value is still July the 1st until you click a date in September. Is there a way I can access the value of the dropdown box. If i knew in vba which month was selected at the time I can write some vb so set the calender to the 1st of that month, prompting the change of date.

thanks

Chris

---

Answer from Richard Rost:

I don't believe you can change the behavior of that calendar control. It doesn't get a value until someone selects an actual date.

If all you need is just a list of months, then why not just create two drop downs - one for year (2000, 2001, etc.) and then another with the 12 months. Have them pick values in both of these boxes and then run your event.

The alternative, of course, would be to just build your own calendar. I cover this in my Access Calendar Seminar:

http://www.599cd.com/site/courselist/seminars/access-calendar/?key=BlFAlEx

I just spent about 20 minutes playing with the calendar control, and I found that there are events that fire when the Month and Year dropdown boxes are changed (NewMonth and NewYear) but I could not find any way to access those values. It's not a property of the control. I tried searching on Google for some explanation of how to do this, with no luck.

If anyone else knows how to access the Month and Year properties of the Calendar control, that would be a great help.

Sorry I couldn't be of more assistance. Since I usually build my own calendar controls, I don't really have a ton of experience with the Microsoft calendar control.

Oh… hold on… I found it. There is a way you can access those properties, but it's a LOT of code. Here's a link:

http://support.microsoft.com/kb/193967

Hope this helps.