Color Activex Calendar Control in Access Form 1

[chrisbee]

Hi

The ActiveX (MSCAL.Calendar.7) Calendar Control. What I am trying to do is change the colour of all the Saturday dates - or better still only allow the Saturdays to be clicked on. Do I have a hope?

 

[MajP]

Can not Change the colors. But you could do something like this

Private Sub Calendar5_Click()
If Not Weekday(Calendar5) = 7 Then
MsgBox "Can only choose Saturdays."
Calendar5.Value = Calendar5.Value + (7 - Weekday(Calendar5))
End If
End Sub

Pops up a message and then moves it to the first Saturday.

 

[chrisbee]

Elegant - will do the trick thatks