Calander Set Date to End Of Current Month

M

Mickey Wells

I currently have a calander set to default to today when opened. Is there a way to set the code to default to last day of current month

Mickey
 
P

PC Datasheet

Put this code in the OnOpen event of your calendar form:
Me!NameOfCalendarControl.Value = DateSerial(Year(Date()), Month(Date())+1, 1-1)


--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
[email protected]
www.pcdatasheet.com




Mickey Wells said:
I currently have a calander set to default to today when opened. Is there a
Click to expand...
way to set the code to default to last day of current month?
 
M

Mickey Wells

My calander now defaults to an April 10th date, I am guessing that somewhere in the form is this date. Would you agree
 
Top