Calendar Control 11.0

[paulscherm]

Hello everyone,

I've been working with Access for years but there is one thing that seems to elude me.

I have inserted a Calendar Control 11.0 onto my form but it doesn't "update". It stays on the day I inserted it on my form and "highlights" that day. It won't change day to day or month to month for that matter.

Any help would be appreciated.

 

[mdlueck]

When I was working with the calendar control OCX, then I found I needed to refresh it to the Now() date when the form opened, even if it was suppose to be a blank date. In that case I set it to Now() and the right away blanked the value. Then when the control was activated, it always was preset to the current date.

 

[paulscherm]

Thanks for the reply. You said you needed to "refresh" the calendar to the Now() date. Am I suppose to create a text box and link it to the calendar?

 

[Trevor G]

Try this, open the form in design view and then select the properties in the Event tab use the On Load event and click the Elipsee button and select Event Procedure then adjust the following to you calendar name

Private Sub Form_Load()
Me.Calendar0 = Date

End Sub

 

[mdlueck]

You said you needed to "refresh" the calendar to the Now() date. Am I suppose to create a text box and link it to the calendar?

I merely set the value of the control to be Now() and then set it to vbNullString to blank the value back out. Doing so was enough to tell the control which date to default to once the date field is enabled... is defaults to today's date.