default date = 01/01/this year

[Dave]

Access 2003
on load event of a form
unbound text box

trying to get it to display the first day of the current year.

Here is what I have tried:

txtStartDate = "01/01/ " & " year(date)"

as usual I am betting I have "quoits" or "&" issues

Thanks in advance,

dave

 

[Rick Brandt]

Access 2003
on load event of a form
unbound text box

trying to get it to display the first day of the current year.

Here is what I have tried:

txtStartDate = "01/01/ " & " year(date)"

as usual I am betting I have "quoits" or "&" issues

=DateSerial(Year(Date()), 1, 1)

 

[Dave]

Thank you sir.

dave

=DateSerial(Year(Date()), 1, 1)

 

[Dave]

Thank you also

dave

Hi -

Take the Year(date) out of the quotes:

txtStartDate = "01/01/ " & year(date)


John




--
John Goddard
Ottawa, ON Canada
jrgoddard at cyberus dot ca

Message posted via AccessMonster.com