Question on Calendar Control

J

JP Martinez

I have a simple form where I need to attach a calendar control that stays
updated as days change. I noticed that when I loaded the calendar control in
Access 2000, there is more to do that simply dragging the control - what
would be the sugegsted code and do I need a table for the daily changing
data to fall in?

Any help will be appreciated

thanks

-Pierre
 
V

Van T. Dinh

Not sure of your question but if you meant you want the Calendar to show
today's date then you can use the Form_Load Event to set the value of the
CalendarControl like:

Private Sub Form_Load()
Me.Calendar0 = Date
End Sub


Alternatively, you can substitute the assignment statement above with the
Today Method like:

Me.Calendar0.Today
 
J

JP Martinez

Hi thanks for the answer but when I created the control- checked on its name
and then went to the code editing section I entered

Private Sub Form_Load()
Me.ActiveXCtl58 = Date
End Sub

Every time it complains about Date and does not execute properly. - I tried
date() to no avail.

Any ideass
-JPierre
 
Top