Calander control

[suepowell]

Hi

I have put a calander control onto a form, and when the user clicks on a date, that date is put into a control on the form. This works fine, but when I open the form, the control always shows the date Iput the control on the form (13th june 2003) rather than today or even this month.

This is anoying the users as they have to change the month every time before they can pick a date. I can't see a way of setting the calander controls default value, so does anyone out there know how to do this? I works the same on 97 and 2000.

Thanks

Sue

 

[Jack Cowley]

In the forms On Open event put code similar to this:

Me.NameOfCalendarControl.Value = Date()

Now the calendar will open at todays date....

hth,
Jack

PS. If the parenthesis disappear after Date that is OK. Just do not have any controls or fields named Date as Date is a reserved word in Access.