How do you make an unbound calendar control default to current dat

D

DataGeek

I can't get an unbound calendar control to default to the current date. I've
tried using calendar.value = DATE in the "on open" and "on load" and it does
nothing. I've tried all the permutations I can think of: calendar.value,
me.calendar.value, forms!form!calendar.value and DATE, Today, Now.

I'm working with a 2000 database with Access 2003. I'm using the calendars
to set a starting and ending date for a series of reports and that part works
just fine. I just want both calendars to show the current date to start with
and can't seem to get that part done. It's driving me crazy!
 
D

DataGeek

Also, I've tried me.calendar.today and me.calendar.date, etc. etc. etc. <sigh>
HELP!
 
C

Chris B via AccessMonster.com

Looks like you forgot the (), place =Date() into the
Default Value parameter
I can't get an unbound calendar control to default to the current date. I've
tried using calendar.value = DATE in the "on open" and "on load" and it does
[quoted text clipped - 5 lines]
just fine. I just want both calendars to show the current date to start with
and can't seem to get that part done. It's driving me crazy!
 
D

DataGeek

Thanks!
What actually finally worked was Me.Calendar1.Today
But it wouldn't work "on open" nor did it work "on load" until I placed all
my "on open" commands into the "on load" with it - then it worked.
Go figure...



Chris B via AccessMonster.com said:
Looks like you forgot the (), place =Date() into the
Default Value parameter
I can't get an unbound calendar control to default to the current date. I've
tried using calendar.value = DATE in the "on open" and "on load" and it does
[quoted text clipped - 5 lines]
just fine. I just want both calendars to show the current date to start with
and can't seem to get that part done. It's driving me crazy!
 
Top