calendar Control

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jon - 29 May 2008 12:54 GMT

According to documentation EndDateCalendar.Value = Date will display the
current date in the calendar control. I have the control bounded to a field.
I'm not sure how or where to place this statement to get it to work properly.
Any help would be greatly appreciated.

Jon

Reply to this Message

Linq Adams - 29 May 2008 13:21 GMT

If the calendar is bound to a field, I assume you only want the calendar set
to the current date if you're entering a new record, so maybe something like
this:

Private Sub Form_Current()
If Me.NewRecord Then
EndDateCalendar.Value = Date
Else
EndDateCalendar.Value = Me.EndDateCalendar.Value
End If
End Sub

Signature

There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000/2003

Reply to this Message