Changing colour of date in calendar control

[raccoon]

I have a notes table in my database. I have used a calendar control so that if you click on a date it gives you any notes made for that date and lets you enter new ones. What I would like to do, when the form with my calendar control is loaded, if there are any notes for a certain date, change either the background colour or the font of those dates to a different colour. The query to tell me if there are any notes is basically a select of all distinct dates in the notes table. What I can't work out is, when I have the dates, how do I tell the calendar control to change the color of the specified dates? All ideas welcome!!!

PS this is a great site!!

 

[Mile-O]

You can't do what you want with the Calendar Control but there is another option...


...you create your own calendar.

I'm sure if you search for calendar by ColinEssex on this forum you'll find a database example with a home-made calendar that you can customise to your needs.