Calendar Control

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do you set the properties on a calendar control to always come up with
todays date, but still have the ability to change the date
 
I assume that you are referring to the Microsoft ActiveX Calendar control.

In the Current event of the form containing the control, add the following
line:
Me.MyCalendarControlName.Value = Date
(substituting the correct name for your control).

Note: this will not work in the form's Open event!

HTH,

Rob
 
Thanks Rob, it works

Rob Parker said:
I assume that you are referring to the Microsoft ActiveX Calendar control.

In the Current event of the form containing the control, add the following
line:
Me.MyCalendarControlName.Value = Date
(substituting the correct name for your control).

Note: this will not work in the form's Open event!

HTH,

Rob
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If Then Not working Properly 9
Excel VBA to go to specific sheet & cell in the current workbook not working. 2
Calendar Control - HELP 1
Current Date for Calendar Control 1
Calendar To Stay at Last Date Entered 3
Popup calendar in a form 2
How to set the Calendar control's background as transaparent? 1
Calendar Control Issue - Revisited 2

Back
Top