Set Calendar To Today

G

George

I inserted the MSCAL.Calendar.7 in my form and
I am trying to get it to always open to todays date.
How can I make this happen ?

Thanks - George
 
J

Jeff Conrad

Assuming you are talking about the ActiveX Calendar control
that ships with Access, then just add this one line of code to
the Form's Load event:

Private Sub Form_Load()
Me.MyCalendarNameHere.Today
End Sub

Just insert your actual control name where it says,
"MyCalendarNameHere"

Compile the code, save and close the form.
When you open the form the calendar will
default to the current date.

--
Jeff Conrad
Access Junkie - MVP
http://home.bendbroadband.com/conradsystems/accessjunkie.html
Access 2007 Info: http://www.AccessJunkie.com

in message:
 
G

George

Thanks - That works

Sorry to post twice, received error message post didn't go thru.

George
 
Top