Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

MS Calendar V.8 Active X not defaulting to todays date? 2

Status
Not open for further replies.

Nelz

Programmer
Sep 27, 2001
50
US
Anyone else ever had this problem. All the settings seem to be correct, but the date shown when you open the calendar form remains at the date I built the form. Really bizarre...
Otherwise this date picker form works great. Anyone have any ideas? This is the ActiveX calendar object that comes with access.

The setting for value is null is NO...which is supposed to default to todays date. My computer clock is fine, I checked that too.
 
OK...I found a solution in the VB forum. For anyone else who is interested I used this code in the On Current event of the calendar form:


Private Sub Form_Current()
Me![ActiveXCtl4].Value = Date

End Sub

Pretty Simple. Post back here if you need the instructions on how to make a pop-up calendar to choose a date for a date field on a different form. That part was easy too. The only problem was getting it to display today's date as it is supposed to...but again, this worked great.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top