date default value

[Shokoth]

Hi, i want to set a default value for a date field, and i want it to be 01/01/(current Year)
how would i go about doing this.
so if the current date is say 22/04/2007

i want the default value of a field to be 01/01/2007

[ADezii]

Hi, i want to set a default value for a date field, and i want it to be 01/01/(current Year)
how would i go about doing this.
so if the current date is say 22/04/2007

i want the default value of a field to be 01/01/2007

In the Default Value Property for the Field:

=CDate("1/1/" & CStr(Year(Now())))

[Shokoth]

thank you for your help

I also wanted to know how to spread out sql statement over 3 lines.

I am writing an sql update statment in VB.

I have about 12 fields to update.

[code]
strSQL = "UPDATE [tblServiceUserPayments]" & _
"Set [tblServiceUserPayments].[January Payment] = DateSerial(Year(Date()),1,30), [tblServiceUserPayments].[JanPaymentRec] = False, [tblServiceUserPayments].[February Payment] = DateSerial(Year(Date()),2,28), [tblServiceUserPayments].[FebPaymentRec] = False " & _
"WHERE ((([tblServiceUserPayments].JanPaymentRec)= True) " & _
"AND (([tblServiceUserPayments].FebPaymentRec)= True));"
[code]

i have 10 more commands like that, and was wondering if it could be spreaded over several lines instead of one long line?
i have tried a few things, but they presented errors.

[ADezii]

thank you for your help

I also wanted to know how to spread out sql statement over 3 lines.

I am writing an sql update statment in VB.

I have about 12 fields to update.

[code]
strSQL = "UPDATE [tblServiceUserPayments]" & _
"Set [tblServiceUserPayments].[January Payment] = DateSerial(Year(Date()),1,30), [tblServiceUserPayments].[JanPaymentRec] = False, [tblServiceUserPayments].[February Payment] = DateSerial(Year(Date()),2,28), [tblServiceUserPayments].[FebPaymentRec] = False " & _
"WHERE ((([tblServiceUserPayments].JanPaymentRec)= True) " & _
"AND (([tblServiceUserPayments].FebPaymentRec)= True));"
[code]

i have 10 more commands like that, and was wondering if it could be spreaded over several lines instead of one long line?
i have tried a few things, but they presented errors.

It can be spread over several lines as long as you use the Line Continuation Character (_) and Concatenation Symbol (&).