I have 2 DTPickers on my form, when i open the form i want the first one to default to the first day of the current year and the 2nd one to default to the last day of the current year....
Any clues??
Printable View
I have 2 DTPickers on my form, when i open the form i want the first one to default to the first day of the current year and the 2nd one to default to the last day of the current year....
Any clues??
Something like:
dtpStart.value = cdate("01/01/" & Year(date))
dtpEnd.value = cdate("12/31/" & Year(date))
looks like that did the trick... Thanx