calendar control default date?

[Bob Weisenburger]

I have several active-x calendar controls in my access database. I
can't seem to figure out how to set the date on the calendare. In the
"on open" event of my form, I create the following line of code.
"[calendar1].value=date()". This doesn't work. When the form opens,
I would like the calendar to reflect the current date. Please help.

thanks

[Tommy Martin]

On Open try me.[calendar1].value = format(now(), "m/d/yy",vbSunday,
vbfirstJan1)

"Bob Weisenburger" <bo******@hotmail.com> wrote in message
news:77**************************@posting.google.c om...

I have several active-x calendar controls in my access database. I
can't seem to figure out how to set the date on the calendare. In the
"on open" event of my form, I create the following line of code.
"[calendar1].value=date()". This doesn't work. When the form opens,
I would like the calendar to reflect the current date. Please help.

thanks

[Tommy Martin]

My mistake: Do it "On Load" not "On Open"

"Tommy Martin" <ma********@charter.net> wrote in message
news:10*************@corp.supernews.com...

On Open try me.[calendar1].value = format(now(), "m/d/yy",vbSunday,
vbfirstJan1)

"Bob Weisenburger" <bo******@hotmail.com> wrote in message
news:77**************************@posting.google.c om...

I have several active-x calendar controls in my access database. I
can't seem to figure out how to set the date on the calendare. In the
"on open" event of my form, I create the following line of code.
"[calendar1].value=date()". This doesn't work. When the form opens,
I would like the calendar to reflect the current date. Please help.

thanks

[Tommy Martin]

OK, Use "On Load" event:

me.[calendar1].value = date()

"Bob Weisenburger" <bo******@hotmail.com> wrote in message
news:77**************************@posting.google.c om...

I have several active-x calendar controls in my access database. I
can't seem to figure out how to set the date on the calendare. In the
"on open" event of my form, I create the following line of code.
"[calendar1].value=date()". This doesn't work. When the form opens,
I would like the calendar to reflect the current date. Please help.

thanks