calendar value on open

[traffas]

Thank you for reading this and taking time to help a novice.

I have a activeX calendar control on a form. I use the control to select dates for queries. This part works wonderfully. However, everytime i open the form containing the calendar -- it opens to a date in april. I can manually reset the date through by opening it in design mode and setting the value of the control through properties ...... but I can not pass a value ( the current date ) to the calendar by using 'VBA code' or by setting the value to 'Date()'.

How do i get it to open to the current date?

Many thanks
shawn

 

[Cleis]

On your Forms OnLoad event put this:

MonthView = the name of your Calendar

Me.MonthView.Value = Date


Hope this helps

Rich

 

[MazeWorX]

or try this


You can use the Today method to set the value of the Calendar control to today's date.

Syntax

controlname.Today

 

[traffas]

Gentlemen, I am using access 2000. The examples that you have given me do not work. I have tried: 'me.activexctl0.value = today' & 'me.activexctl0.value = date', i've tried activexctl0=date and activexctl0=today. still will not work. These are on the form 'open' event.

The programing looks like it should work, but alas I must be doing something wrong.

help

many thanks in advance......

Shawn

 

[MazeWorX]

Place the code in the forms OnLoad event

Should look like this:

ActiveXclt10.Today

drop the "me"